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,
You can open DevCenter (located in C: --> Program Files --> Cassandra) and write a query.
You need to query the elementdata table belonging to the sldmadb keyspace :
DataMiner general database - NoSQL Database - Cassandra | DataMiner Docs
A sample query : select * from sldmadb.elementdata; would list all columns of this table. You will then need to alter the query based on DMAID, element ID, timestamps by looking at the columns of the elementdata table.
Using this, you can find the value of a parameter at any previous point.