How to convert the stats field to string?

[jieli]

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.

[richgalloway · Accepted solution]

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

[atammana_splunk]

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

[jieli]

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

[richgalloway]

Can you share the relevant dashboard code?

[jieli]

I added a submit button to manually trigger the update.

[richgalloway]

You should ask the OP.