I have a dashboard that contains CSV variable (PUSH, EMAIL, SMS…) and INFO log that looks like that,
Got send PUSH message request
I wonder if there is a way to create query to replace PUSH with my CSV variable, I mean that the filter will look something like that: Got send [variable] message request.
The variable it multi-select.
Hey @almog50
The filter would look something like the following:
| filter matchesPhrase(content, concat("Got send ", $Variable, " message request"))
You’d replace the name of the variable with the name of your variable.
Hope this helps!
Hey @Fin_Ubels
I tried you suggestion but it doesn’t work.
maybe it related to the fact that my $variable is a List (I am using CSV variable)
Sorry I missed the bit about multi select. Just came up with this and tested it, this should work.
data record(content = concat("Got send PUSH message request")),
record(content = concat("Something else"))
| fieldsAdd variable = array($Variable)
| expand variable
| fieldsadd variable = concat("Got send ", variable, " message request")
| filter content == variable