Workflow Issue with Querying Retool Database

Workflows
,
1

I am facing an issue with Retool Workflows.
I am running the following query in both the Retool app and in a workflow:

SELECT * FROM form_submitted;

There are a total of 69 records in the form_submitted table, and the query in the app correctly returns all 69 records. However, when running the same query in the workflow, only 6 records are returned. This behavior is inconsistent and unexpected.

To ensure there is no oversight on my end, I have attached screenshots for your reference.

I would greatly appreciate it if you could assist me in resolving the issue at the earliest.

In the screenshot below you can see there are 69 records in the form_submitted table:

retool db
retool db3568×242 40.4 KB

Querying the same table in the workflow only returns 6 records:

query in workflow
query in workflow788×1000 36.8 KB

And querying the same table inside the app returns the correct data:

query in app
query in app1014×1864 76.4 KB

What can be the issue and how to fix it?

Best regards,
Shehroz Irfan

2 Likes
2

Just to double check - the 69 records are in your production environment - can you confirm that is the same environment you are querying in the workflow (or that you don't have any other environments with 6 records in that table...)?

3 Likes
3

Hi,
Thank you for the response, yeah I checked that it was due to environment, I don't know how but it was changed to staging from production and caused the issue. But now it's fixed.

2 Likes