# DQL with placeholder variable

**URL:** <https://community.dynatrace.com/t/dql-with-placeholder-variable/49532>\
**Category:** Dashboarding\
**Tags:** dql, filter\
**Created:** [January 1, 2025, 6:11pm UTC](https://community.dynatrace.com/t/dql-with-placeholder-variable/49532 "2025-01-01T18:11:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![almog50](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@almog50](https://community.dynatrace.com/u/almog50)\
**Post date:** [January 1, 2025, 6:11pm UTC](https://community.dynatrace.com/t/dql-with-placeholder-variable/49532/1 "2025-01-01T18:11:18Z")

</div>

I have a dashboard that contains CSV variable (PUSH, EMAIL, SMS…) and INFO log that looks like that,

```markup
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.

---

<div class="post-metadata">

**Author:** ![Fin\_Ubels](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/fin_ubels/32/18008_2.png) [@Fin\_Ubels](https://community.dynatrace.com/u/Fin_Ubels)\
**Post date:** [January 2, 2025, 3:17am UTC](https://community.dynatrace.com/t/dql-with-placeholder-variable/49532/2 "2025-01-02T03:17:49Z")

</div>

Hey&nbsp;[@almog50](https://community.dynatrace.com/user/84772)

The filter would look something like the following:

```markup
| 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!

---

<div class="post-metadata">

**Author:** ![almog50](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@almog50](https://community.dynatrace.com/u/almog50)\
**Post date:** [January 2, 2025, 8:55am UTC](https://community.dynatrace.com/t/dql-with-placeholder-variable/49532/3 "2025-01-02T08:55:39Z")

</div>

Hey&nbsp;[@Fin\_Ubels](https://community.dynatrace.com/user/47376)

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)

---

<div class="post-metadata">

**Author:** ![Fin\_Ubels](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/fin_ubels/32/18008_2.png) [@Fin\_Ubels](https://community.dynatrace.com/u/Fin_Ubels)\
**Post date:** [January 2, 2025, 11:38pm UTC](https://community.dynatrace.com/t/dql-with-placeholder-variable/49532/4 "2025-01-02T23:38:57Z")

</div>

Sorry I missed the bit about multi select. Just came up with this and tested it, this should work.

```markup
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

```
