I have a low code app where i’m filling data that I fetch from dataminer using GQI. The LCA table has trigger control using which i auto refresh the table. Also im dealing with pagination because we are dealing with huge data.
My question is, will the trigger controll call the whole GQI script again or only the GetNextPage()?
Any visualization that consumes a GQI as data will do the following when it receives a retrigger (either through a trigger component or an action):
- Terminate the current active session, if it was still open.
- Open a new session.
- Fetch pages until the state of the previous session is restored (e.g., the scroll position in the table).
There are basically two ways to have updated data: Realtime updates or through refresh triggers. When not dealing with realtime updates, GQI is not aware of any changes to the rows that were already sent to the client. It’s a snapshot of the data taken at the moment when the query was executed. So in order to know the latest state of the data (deleted/updated/added rows), everything needs to be refetched from the start.