Timespan Filter over Table – Dashboards

Solved505 views
5
1 Comment

Hello all

I'm filling a table from a parameter table and when i try to filter using timespan i get this error, any idea why ?

"There are no properties for 'Timespan' that match your column type'

I did the same but fillling from Get Alarms and it works fine, any idea ?

Tiago Pinhao [SLC] [DevOps Enabler] Selected answer as best 4th April 2023
Tiago Pinhao [SLC] [DevOps Enabler] commented

Hello Guys … No answer 🙁

1 Answer

1
12.45K 2 Comments

Hi Tiago,

I believe the SLA connector should be improved so the timestamp columns are no longer of type 'string'. Due to it being a string column, we have no time related filtering capabilities in GQI and dashboards.

Protocol:

And as a result in GQI:

Tiago Pinhao [SLC] [DevOps Enabler] Posted new comment 4th April 2023
Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented

As a workaround you could create a ‘Custom operator’ that transform the string to a datetime column. As with any workaround it has side effects. The filtering will occur in GQI and not on the data source so you’ll notice this on big data sets.