https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628775#M51568 <P>Inside the XML you need to escape characters</P><P>so&nbsp;</P><LI-CODE lang="markup">|eval Category=case (Ratings &amp;gt; "8","Promoter",Ratings &amp;gt; "7","Detractor",Ratings &amp;gt; "6" AND Ratings &amp;lt; "9", "Passive")</LI-CODE><P><A href="https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents#:~:text=XML%20escape%20characters,the%20W3C%20Markup%20Validation%20Service" target="_blank">https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents#:~:text=XML%20escape%20characters,the%20W3C%20Markup%20Validation%20Service</A>.</P><P>Actually you don't need to escape the &gt; to &amp;gt; but it's probably good practice.</P> Sun, 29 Jan 2023 23:34:01 GMT bowesmana 2023-01-29T23:34:01Z https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628774#M51567 <P>Hi Experts,&nbsp;</P> <P>While adding below query to my dashboard i am getting error saying&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>|eval Category=case (Ratings&gt;"8","Promoter",Ratings &gt; "7","Detractor",Ratings &gt; "6" AND Ratings &lt; "9", "Passive")</P> <P>Error:&nbsp;<SPAN>Unencoded &lt;</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Macky_29_0-1675029081860.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/23604i3B21AFD53E03B41D/image-size/medium?v=v2&amp;px=400" role="button" title="Macky_29_0-1675029081860.png" alt="Macky_29_0-1675029081860.png" /></span></P> <P>&nbsp;</P> <P><SPAN>Regards</SPAN></P> <P><SPAN>Mayank</SPAN></P> <P>&nbsp;</P> Mon, 30 Jan 2023 16:16:55 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628774#M51567 Macky_29 2023-01-30T16:16:55Z https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628775#M51568 <P>Inside the XML you need to escape characters</P><P>so&nbsp;</P><LI-CODE lang="markup">|eval Category=case (Ratings &amp;gt; "8","Promoter",Ratings &amp;gt; "7","Detractor",Ratings &amp;gt; "6" AND Ratings &amp;lt; "9", "Passive")</LI-CODE><P><A href="https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents#:~:text=XML%20escape%20characters,the%20W3C%20Markup%20Validation%20Service" target="_blank">https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents#:~:text=XML%20escape%20characters,the%20W3C%20Markup%20Validation%20Service</A>.</P><P>Actually you don't need to escape the &gt; to &amp;gt; but it's probably good practice.</P> Sun, 29 Jan 2023 23:34:01 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628775#M51568 bowesmana 2023-01-29T23:34:01Z https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628824#M51573 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/253271">@Macky_29</a>&nbsp;<BR /><BR />Below is the mapping of special characters with html entty, either you can use mapping word<BR /><BR />enclose the query in cdata tags</P><PRE>&lt;![CDATA[ &lt;content_with_special_characters&gt; ]]&gt;</PRE><P>&nbsp;<BR /><BR /><A href="https://docs.splunk.com/Documentation/SplunkCloud/latest/Viz/OverviewofSimplifiedXML" target="_blank">https://docs.splunk.com/Documentation/SplunkCloud/latest/Viz/OverviewofSimplifiedXML</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SanjayReddy_0-1675082027619.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/23605iA12DB72CA084DF88/image-size/medium?v=v2&amp;px=400" role="button" title="SanjayReddy_0-1675082027619.png" alt="SanjayReddy_0-1675082027619.png" /></span></P><P>&nbsp;</P> Mon, 30 Jan 2023 12:35:56 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Why-am-I-receiving-error-while-adding-query-to-dashboard/m-p/628824#M51573 SanjayReddy 2023-01-30T12:35:56Z