<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: DQL variable with tag values stopped working in DQL</title>
    <link>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219347#M157</link>
    <description>&lt;P&gt;Hey Marcio,&lt;/P&gt;
&lt;P&gt;For such an error I would suggest opening a support ticket if you haven't already so that they can look deeper behind the scenes.&lt;/P&gt;
&lt;P&gt;In the meantime, would a different query like this work in your situation?&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Fin_Ubels_0-1690843489566.png" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/13242i232F9F1841C20984/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Fin_Ubels_0-1690843489566.png" alt="Fin_Ubels_0-1690843489566.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 31 Jul 2023 22:46:39 GMT</pubDate>
    <dc:creator>Fin_Ubels</dc:creator>
    <dc:date>2023-07-31T22:46:39Z</dc:date>
    <item>
      <title>DQL variable with tag values stopped working</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219258#M154</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;We were using a Dashboard with a selector filter that has the existing values of a tag in our hosts for the use case of this Dashboard, but this week the DQL query using the variable stopped working (before it was working normally).&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Query DQL:&lt;/STRONG&gt;&lt;BR /&gt;&lt;BR /&gt;fetch dt.entity.host&lt;BR /&gt;| fieldsAdd tags&lt;BR /&gt;| expand tags&lt;BR /&gt;| summarize tags = collectDistinct(tags)&lt;BR /&gt;| expand tags&lt;BR /&gt;| parse tags, """((LD:tag (!&amp;lt;&amp;lt;'\\' ':')LD:value) |LD:tag)"""&lt;BR /&gt;| fields tag = replaceString(tag, """\:""", ":"), value = replaceString(value, """\:""", ":")&lt;BR /&gt;| filter toString(tag) == "MyTag"&lt;BR /&gt;| fields value&lt;BR /&gt;&lt;BR /&gt;Could anyone support?&lt;/P&gt;</description>
      <pubDate>Mon, 31 Jul 2023 01:53:54 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219258#M154</guid>
      <dc:creator>MarcioKaue</dc:creator>
      <dc:date>2023-07-31T01:53:54Z</dc:date>
    </item>
    <item>
      <title>Re: DQL variable with tag values stopped working</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219260#M155</link>
      <description>&lt;P&gt;Hey Marcio,&lt;/P&gt;
&lt;P&gt;I ran the same query in my environment and it is working just fine. Could you provide some context as to what about it isn't working and what its purpose is?&lt;/P&gt;
&lt;P&gt;In my below example I tagged a synthetic with "Test:SomeTag" and the query, as expected, returns "SomeTag" when the input tag string is "Test":&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Fin_Ubels_0-1690773350692.png" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/13216iA51330129B74FF9D/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Fin_Ubels_0-1690773350692.png" alt="Fin_Ubels_0-1690773350692.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 31 Jul 2023 03:17:20 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219260#M155</guid>
      <dc:creator>Fin_Ubels</dc:creator>
      <dc:date>2023-07-31T03:17:20Z</dc:date>
    </item>
    <item>
      <title>Re: DQL variable with tag values stopped working</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219321#M156</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/47376"&gt;@Fin_Ubels&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;I need to bring all the values of a tag to use as a variable in a Dashboard.&lt;/P&gt;&lt;P&gt;Here is an example, if I even use the "parse" function, the DQL returns all tags and values&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DQL-sucess.PNG" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/13237iC5BD9F44A54C191F/image-size/medium?v=v2&amp;amp;px=400" role="button" title="DQL-sucess.PNG" alt="DQL-sucess.PNG" /&gt;&lt;/span&gt;&lt;BR /&gt;&lt;BR /&gt;If I filter by a tag value, the error I mentioned occurs:&lt;BR /&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DQL-error.PNG" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/13236i996CA27160F9ACB4/image-size/medium?v=v2&amp;amp;px=400" role="button" title="DQL-error.PNG" alt="DQL-error.PNG" /&gt;&lt;/span&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 31 Jul 2023 14:25:53 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219321#M156</guid>
      <dc:creator>MarcioKaue</dc:creator>
      <dc:date>2023-07-31T14:25:53Z</dc:date>
    </item>
    <item>
      <title>Re: DQL variable with tag values stopped working</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219347#M157</link>
      <description>&lt;P&gt;Hey Marcio,&lt;/P&gt;
&lt;P&gt;For such an error I would suggest opening a support ticket if you haven't already so that they can look deeper behind the scenes.&lt;/P&gt;
&lt;P&gt;In the meantime, would a different query like this work in your situation?&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Fin_Ubels_0-1690843489566.png" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/13242i232F9F1841C20984/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Fin_Ubels_0-1690843489566.png" alt="Fin_Ubels_0-1690843489566.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 31 Jul 2023 22:46:39 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219347#M157</guid>
      <dc:creator>Fin_Ubels</dc:creator>
      <dc:date>2023-07-31T22:46:39Z</dc:date>
    </item>
    <item>
      <title>Re: DQL variable with tag values stopped working</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219417#M158</link>
      <description>&lt;P&gt;I was able to identify that the "&lt;EM&gt;fields&lt;/EM&gt;" function for some reason was not being accepted (the error message is not clear as to why).&lt;/P&gt;&lt;P&gt;Here is the DQL that brings the same result in another way:&lt;/P&gt;&lt;P&gt;fetch dt.entity.host&lt;BR /&gt;| expand tags&lt;BR /&gt;| summarize tags = collectDistinct(tags)&lt;BR /&gt;| expand tags&lt;BR /&gt;| parse tags, """((LD:tag (!&amp;lt;&amp;lt;'\\' ':')LD:value) |LD:tag)"""&lt;BR /&gt;| fieldsAdd tag = replaceString(tag,"""\:""", ":"), value = replaceString(value, """\:""", ":")&lt;BR /&gt;| filter toString(tag) == "MyTag"&lt;BR /&gt;| fieldsRemove tags, tag&lt;/P&gt;</description>
      <pubDate>Tue, 01 Aug 2023 12:57:48 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-variable-with-tag-values-stopped-working/m-p/219417#M158</guid>
      <dc:creator>MarcioKaue</dc:creator>
      <dc:date>2023-08-01T12:57:48Z</dc:date>
    </item>
  </channel>
</rss>

