hello community,
I need to get the values in a table (which have an the trending activated) but from some moments in the past. As I need 3 values from a table of 400 lines, I can't use the normal trend display for this without loosing days of work.
Is there a way to get these information with some SQL query or a magic function in Dataminer?
P.S. We are running your DMS with Cassandra.
Kind regards
Romain

Hi Romain,
A possible option is using GQI queries to get historic data. You could use the data source 'Get parameter table ID' and enable the box 'History'. Below an example:
You can export this information to a CSV file. In case you would like to generate this export in a scheduled base, you could use Data Aggregator.
Hope it helps.
Hi,
I see that this question has been inactive for some time. Do you still need help with this? If not, could you select the answer that has been most helpful for you (using the ✓ icon)?