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.
The |s
token suffix will put the token value within quotation marks. For example, where code=$tokenname|s$
.
The |s
token suffix will put the token value within quotation marks. For example, where code=$tokenname|s$
.
Hey @richgalloway - were you able to achieve your desired solution with this?
It worked, thanks.
But the subquery does not automatically run when I select another token value from the dropdown. What am I missing?
Can you share the relevant dashboard code?
I added a submit button to manually trigger the update.
You should ask the OP.