Hi Dojo,
in a low-code app, is there a way to link the time range feed to a table and have the display period selected when selecting the time range, as one column contains the date and time?
Otherwise, is it possible to use a checkbox or even buttons and have a GQI query on the table select only the appropriate dates?
Thank you
Hi Marco,
I believe it should be possible. When configuring the GQI query, you can filter based on a time range feed. You will need to configure two filters:
- From
- To
Table Components:
Hope it helps.
Hi Marco,
Please could you let me know which specific component are you using:
– Parameter table (1)
– Alarm table (2)
– Pivot table (3)
– Table (4)
The example above uses a ‘Table’ component. The source data is a GQI query.
I use `Table` component (4) but using the filter `get alarms` I don’t find my column. I use `get parameters for elements where…` The example you used don’t work for me
Hi Marco,
As you mentioned, the example above uses the data source ‘Get Alarms’. This data source will retrieve the list of alarms in your system. One of the columns of this data source is the ‘Root Time’. The example uses the ‘Root time’ column (a datetime column) in combination with the time range feed to filter based on timestamps.
The purpose of this example is to show you the possibility that, if you have a GQI query that contains a datetime column, you could use the time range feed to filter based on timestamp. It is not the intention that you have to modify your GQI query to include the ‘Get Alarms’ data source.
In order to help you with this case, can you include a screenshot of your GQI query and the result?
Thank you, Miguel. I will try to explain myself better. I have a table that has several columns, A, B, C, D… Column C is a datetime column. I want to use this column with the time range feed. Using the source get parameters for items where, I cannot find the feed time range when I filter for the datetime column. Filter method are `contains`, `equals`, `regex`… not `greater than` or `lower than`. If I change the source it works but I don’t have the data because it is obviously in a different source. Hope this is a bit clearer. I posted a photo. thank you
Thank you Miguel but I don’t understand how to connect my table to the feed. I have a normal table with a column `datetime`. My whish is to use the time range feed to filter on this column.
Thank you