All Apps and Add-ons

How to convert the stats field to string?

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

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, an upvote would be appreciated.

View solution in original post

0 Karma

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, an upvote would be appreciated.

View solution in original post

0 Karma

Splunk Employee
Splunk Employee

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

0 Karma

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

SplunkTrust
SplunkTrust

Can you share the relevant dashboard code?

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

New Member

I added a submit button to manually trigger the update.

0 Karma

SplunkTrust
SplunkTrust

You should ask the OP.

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