GQI table data needs to be updated real time whenever any change happens for parameter values, which comprises of list of services -> list of elements -> list of params
So as soon as any value change for any parameter the row should be immediately updated, how to have it with real time updates, as my code in GetNExtPage comprises of creating rows with caching involved.
Now, for updates do I also need to attach trigger on my table?
Hi Apurva,
If you need actual real-time updates without any delay, you don’t need to link a trigger component to your table. Instead, your ad hoc data source can implement the IGQIUpdateable interface to publish row updates whenever they happen.
If you then enable the “Update data” setting of your table component, it can receive update notifications from your data source.
In your ad hoc data source, in order to receive notifications of services/elements/parameters you can subscribe on the relevant SLNet events via the same connection you use to fetch the data.
Note that since you’re are caching data, you should be using a dedicated SLNet connection (this is a temporary workaround for an upcoming feature) per possible security group combination of your users.
Considering performance, if you’re table result consist of many separate services and parameters (~50+), it’s probably not advisable to maintain subscriptions for each of those.