I'm currently building an LCA which will trigger an adhoc datasource to fetch information based on a selection made in an table. I want the user to be able to multiselect in the table, however i want to only execute the fetch data when i press on an button in the LCA for performance issues (fetching and parsing the data is a bit slow, so i want to try and not update everything until the user want to fetch the data)
How can i do this?
in short, i have an input linked to an table index where i then can have multiple entries selected, however i only want to update this when the user clicks an button.
I've tried looking at flows, but these does not block request until an boolean or variable is an certain value
I've looking into creating an variable table to copy the selection, however i can only copy one selection at the time.
Hi Gerwin,
There is currently no way to trigger query execution without adding the query to a component.
I can think of a (complicated) way to implement this:
- Create a script that takes all selections as an input and writes them to a file. This script should be triggered from the button that should update the query result.
- The ad hoc script should have a file watcher that triggers on edits of that file. This event can then be used to remove all previous rows & add the required new rows based on the file contents using real-time updates.
There are probably some other (& better) ways to do this, this is just my first idea.
The OnStartUpdates is only used to provide your class with the IGQUpdater object. Once you have that reference, you can start listening to file changes with a file watcher and trigger GQI row updates using it.
When you choose no custom row id, GQI will fill them in before sending them to the client. In that case, the value of the id is the index of the row.
Looking into this i need to add an public void OnStartUpdates(IGQIUpdater interface, how can i access the table from here? Or do i need to track the row id's myself?
What counts towards the row id? First collumn?
Found some more examples here: https://github.com/SkylineCommunications/SLC-GQIDS-CSV/blob/main/SLC-GQIDS-CSV_1/SLC-GQIDS-CSV_1.cs
or can i call the GQIPAge GetNextPage function?