Simple question - Workflow save fetched result without "double query"

Ask us anything
1

Hi,

i have a simple question with setting a variable after fetching from, lets say, the database.

For now, i always have to fetch the database first and after that i will have a “Change variable” which is pointing again to the database to set the value in my variable. Basically i am requesting twice.

image
image1140×1015 62.9 KB

If i remove the “Fetch Collection” in this example. The variable stays empty.

Is there a way, to set a variable without double fetching?
Since the “Fetch Collection” doesnt give me any result in the action tab.

Thanks

2

Hi @IKR :slight_smile:
When performing a Fetch collection, it updates the collection directly. The Action returns nothing.
You can use the userImages collection variable directly on your element and it will update the data when you perform that workflow.

Alternatively, if you need to return something from your first action, you can use the Database | Select action from Supabase :slight_smile:

Hope that makes it a bit clearer!