topic DQL with placeholder variable in Dashboarding

DQL with placeholder variable

almog50 — Wed, 01 Jan 2025 18:11:18 GMT

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.

Re: DQL with placeholder variable

Fin_Ubels — Thu, 02 Jan 2025 03:17:49 GMT

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!

Re: DQL with placeholder variable

almog50 — Thu, 02 Jan 2025 08:55:39 GMT

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)

Re: DQL with placeholder variable

Fin_Ubels — Thu, 02 Jan 2025 23:38:57 GMT

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