Dashboards & Visualizations

Dropdown wildcard

dbcase
Motivator

Hi,

I have a dropdown that lists individual values (example, 1,2,3,4,5) with a token num. The query looks like this

index=blah numberfield="$num$"

And that works just fine

What I'd like to do is to be able to select ALL values (i.e. ). The dropdown would now have values of *,1,2,3,4,5). Easy enough. The question is how do I structure the query? By using the one above I get no matches because the numberfield is never = "".

Help?

Tags (2)
0 Karma
1 Solution

dbcase
Motivator

Found it!

Change the * to %

then use the like command

search|where like(numberfield,"$num$")

View solution in original post

0 Karma

dbcase
Motivator

Found it!

Change the * to %

then use the like command

search|where like(numberfield,"$num$")

0 Karma

dbcase
Motivator

well darn it, the asterisk did show. The last sentence is supposed to read like this

What I'd like to do is to be able to select ALL values (i.e. *). The dropdown would now have values of *,1,2,3,4,5). Easy enough. The question is how do I structure the query? By using the one above I get no matches because the numberfield is never = "*".
0 Karma
Get Updates on the Splunk Community!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...