Query returning invalid results

Queries and Resources
1

I have a query that is running a select statement against Postgres and after I update some data and run the query again, some of the updated data is not displaying the results from the Retool query but if I query Postgres directly with the same exact query the updated values are there. I do no have caching enabled and have also called the invalidateCache() function but still do not see the updated values in the Retool query. I have also noticed that after a period of time, the updated values eventually are returned by the Retool query which leads me to believe there is some caching occurring somewhere in the Retool layer.

Has anyone else experienced this or have any tips on how to resolve this? Thanks!

2

Can you provide some screenshots of the query and the output?

3

Hello @brycehemme!

Are you following the below steps for viewing and updating your table data?

  1. Query to display data in table
  2. Make edits to edit
  3. Make query to save updated table data from Retool to Postgres
    -On success of the update query, run the first query to re-fetch the updated table data

Here is another post about ensuring that any caching you have in invalidated.

Along with our official docs on invalidating caches, hope these help!