Why am I receiving error while adding query to dashboard?

[Macky_29]

Hi Experts, 

While adding below query to my dashboard i am getting error saying  

|eval Category=case (Ratings>"8","Promoter",Ratings > "7","Detractor",Ratings > "6" AND Ratings < "9", "Passive")

Error: Unencoded <

Macky_29_0-1675029081860.png

Regards

Mayank

[SanjayReddy]

Hi @Macky_29 

Below is the mapping of special characters with html entty, either you can use mapping word

enclose the query in cdata tags

<![CDATA[
<content_with_special_characters>
]]>

 

https://docs.splunk.com/Documentation/SplunkCloud/latest/Viz/OverviewofSimplifiedXML

SanjayReddy_0-1675082027619.png

[bowesmana · Accepted solution]

Inside the XML you need to escape characters

so 

|eval Category=case (Ratings > "8","Promoter",Ratings >  "7","Detractor",Ratings >  "6" AND Ratings < "9", "Passive")

https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents#:~:....

Actually you don't need to escape the > to &gt; but it's probably good practice.