All Apps and Add-ons

How to convert the stats field to string?

jieli
New Member

I used a column of the stats table as a dropdown list, so the dropdown token represents a selected cell. But when I try to do a search using the token variable $tokenname$, it's not a string so I couldn't use it to map with where clause.
Here is the field I want to compare:

mvexpand metrics | spath input=metrics | rename "code" as code

Code is a string jsonfield.

The `where code=$tokenname$ does not work because the token is not a string.

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

The |s token suffix will put the token value within quotation marks. For example, where code=$tokenname|s$.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

The |s token suffix will put the token value within quotation marks. For example, where code=$tokenname|s$.

---
If this reply helps you, Karma would be appreciated.
0 Karma

atammana_splunk
Splunk Employee
Splunk Employee

Hey @richgalloway - were you able to achieve your desired solution with this?

0 Karma

jieli
New Member

It worked, thanks.
But the subquery does not automatically run when I select another token value from the dropdown. What am I missing?

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Can you share the relevant dashboard code?

---
If this reply helps you, Karma would be appreciated.
0 Karma

jieli
New Member

I added a submit button to manually trigger the update.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You should ask the OP.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Your Voice Matters! Help Us Shape the New Splunk Lantern Experience

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Building Momentum: Splunk Developer Program at .conf25

At Splunk, developers are at the heart of innovation. That’s why this year at .conf25, we officially launched ...