About img query in the table

Why I added a img field in the input and output, my sql statement can not query the result, is this a bug
You see, remove img and he succeeds。


Hey @Jiayu -

What is the underlying datatype in the table where that image field exists? The Image URL type expects this field to be a text or varchar type.

Pete

Hi @Jiayu as @Pete_Hartnett mentioned the response from Database must be a String. But additionally I found out it must begin with http:// or https://
So that means it must be a valid URL type string…

Hi @Pete_Hartnett
Beautiful day
How do I save the uploaded pictures to the path I specify, because the link to upload pictures will not open in a few days, but I need to save these pictures for a long time, and I can view all the pictures at any time

Hey @Jiayu -

All images in Tulip are stored on an AWS server (or Azure) and the URL you see in tables is just a temporary link to that photo that expires after 24 hours. Within Tulip that link will always be valid (your photo is never deleted) but it is because we handle the reloading of these links when they expire.

There is a feature request to make these links persistent when csv exported, but that work isn’t yet done.

Pete