Dashboard Queries – Matching empty properties

Solved663 viewsdashbaord Queries query filter
1
0 Comments

Hi Dojo,

i'm currently trying to setup a query to count some elements where some specific property is not set:

Unfortunately when trying to use contains or regex i always receive no result. Compared to when doing the same thing with the Polling IP property matching the ones that are empty is working as expected. Do i miss something ?

Thanks in advance!

Manuel Wals [DevOps Advocate] Selected answer as best 24th May 2023

1 Answer

0
15.88K 1 Comment

Hi Manuel,

I was able to reproduce the same behavior. It looks like a possible SW issue but to be confirmed. In the meantime, there is a workaround. Before to perform the filter you could proceed as follows:

  • Use the option Concatenate
    • Column: The element property
    • Format: {0}.Empty
    • New Column Name: "Property Updated"

Then you can perform the filter:

  • Use the option Filter
    • Column: "Property Updated"
    • Filter method: Equals
    • Value: ".Empty"
  • Select: The desired columns, except the new column "Property Updated"

Hope it helps.

Manuel Wals [DevOps Advocate] Selected answer as best 24th May 2023
Manuel Wals [DevOps Advocate] commented

Hi Miguel, many thanks for the workaround. Working perfectly.