topic Re: Handling the ALL token in Dashboards & Visualizations

Why when Handling the ALL token, the code doesn't work?

danielbb — Thu, 07 Apr 2022 15:27:50 GMT

We have the following -

<input type="dropdown" token="Status" searchWhenChanged="false"> <label>Job Status</label> <choice value="*">ALL</choice> <choice value="SUCCESS">SUCCESS</choice> <choice value="FAILURE">FAILURE</choice> <choice value="RUNNING">RUNNING</choice> <default>*</default> <initialValue>*</initialValue> </input>

In the code the following works just fine -

| where STATUS = "$Status$"

Except for the ALL token as the code would be -

| where STATUS = "*"

Instead of -

| where STATUS = *

What can be done?

Re: Handling the ALL token

ITWhisperer — Thu, 07 Apr 2022 06:50:32 GMT

Your issue is not really with the dropdown, it is with the where command

| where STATUS = "*"

would not find all events with any value for status.

Either use

| search STATUS = "$Status$"

Or change the dropdown to

<input type="dropdown" token="Status" searchWhenChanged="false"> <label>Job Status</label> <choice value=".*">ALL</choice> <choice value="SUCCESS">SUCCESS</choice> <choice value="FAILURE">FAILURE</choice> <choice value="RUNNING">RUNNING</choice> <default>.*</default> <initialValue>.*</initialValue> </input>

and use

| where match(STATUS, "$Status$")