How to retrieve historical data from a table used in a Low Code App ?

61 views
2
0 Comments

Hello,

We have a Low Code App displaying data from a table of an element.

Currently, only data from the beginning of the current month is visible.

We need to retrieve historical data from the previous month.

My questions:

  • Does a Low Code App table show only the current snapshot by default?

  • If historical data exists, how can it be retrieved (GQI, SLDataGateway, Cube)?

  • If the table is not trended, does that mean historical data is not stored?

Thank you.

Miguel Obregon [SLC] [DevOps Catalyst] Answered question

1 Answer

0
21.95K 0 Comments

Hi Youssef,

The historical data available in the data source will depend on the TTL configured in your system (see Specifying TTL overrides).

Answering your questions:

  • Does a Low Code App table show only the current snapshot by default?
    See previous comment related to the TTL.
  • If historical data exists, how can it be retrieved (GQI, SLDataGateway, Cube)?
    Depending on what you are looking for, you could use for example the data source Get parameter table by ID (see history checkbox). More advanced queries can be implemented using adhoc data sources.
  • If the table is not trended, does that mean historical data is not stored?
    If the column parameter available in the table is not trended, data will be stored.

In addition, it will be good to understand the use case. Depending on the timespan selected, querying historical data at runtime might not be performant. Is your intention to display all trend data in a table only for inspection? Do you plan to perform some calculations (aggregation) on the historical data?

Hope it helps.

Miguel Obregon [SLC] [DevOps Catalyst] Answered question