Table values from a time in the past

102 views
0
0 Comments

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

Maria Correa [SLC] [DevOps Advocate] Answered question 24th January 2025

3 Answers

0
17.10K 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.