Update the query data/table cache programmatically

💬 Queries and Resources
,
1
  1. My goal:
    I have a button that changes a value in a remote DB through a Rest API call. I want to update that data programmatically within the query data/table_data without triggering the query again on success of the request.
    It may be through updating the changeset.
  2. Issue:
    Refreshing the query takes significant time and is feels sluggish for the user as it has to wait 3 seconds for the table refresh to finish before the next action.
    Both data and changesets are readonly from the Javascript.
2

Hey @AlexisP,

You can create a variable which stores your API's data source, and use the variable as your table's data source.

Then upon each change, you can edit the table, and on the backend run your update query.

I provided an example here

Hope this helps

1 Like
3

It is indeed one of the solutions, but I wanted to avoid it as it breaks some automated paths, such as "data loading" spinner etc.

In the hope some onLoad/onUnload events will come now we have Multipage apps :slight_smile:

1 Like