Table values from a time in the past

507 views
1
1 Comment

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

Marieke Goethals [SLC] [DevOps Catalyst] Posted new comment 26th June 2025
Marieke Goethals [SLC] [DevOps Catalyst] commented

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)?

3 Answers

0
19.82K 0 Comments

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.

Miguel Obregon [SLC] [DevOps Catalyst] Answered question 22nd January 2025
You are viewing 1 out of 3 answers, click here to view all answers.