DQL with placeholder variable

[almog50]

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.

[Fin_Ubels]

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!

[almog50]

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)

[Fin_Ubels · Accepted solution]

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