topic Re: How to use value from a drop down that contains reserved characters in a search? in Dashboards & Visualizations

How to use value from a drop down that contains reserved characters in a search?

robert_adams — Fri, 28 Feb 2020 14:16:25 GMT

I have a table that shows instances of errors from the event log over time by host.

I use a drop down that searches the event log data for Type="Error" | top limit=20 Message to populate $ErrorMessage$ with the value in the Message column. Then I have a table that uses $ErrorMessage$ and does this search:

Type="Error" Message ="$ErrorMessage$" | eval host=upper(host) | timechart count by host

The table and the drop down both default to 24 hour periods.

It works, except when the Message contains reserved characters, like [ or ]. Then I don't get any matches, even though results show in the drop down.

Do I need to escape characters in $ErrorMessage$ when I do my search for the timechart? If so, how do I do that without knowing what characters will show up or how many?

Re: How to use value from a drop down that contains reserved characters in a search?

to4kawa — Fri, 28 Feb 2020 20:19:37 GMT

Drop Down search:

your_search
| stats count values(host) as host by Message 
| sort 20 - count
| nomv host
| rex field=host mode=sed "s/(\S+)/host=\"\1\" OR /g"
| eval searchquery=trim(host,"OR ")

throw searchquery field.

Timechart search:

Type="Error"  $searchquery$" | eval host=upper(host) | timechart count by host

Re: How to use value from a drop down that contains reserved characters in a search?

to4kawa — Fri, 28 Feb 2020 20:19:38 GMT

| makeresults
| eval test="[]{}!\"#$%&'()?>< abddeft ?>_test"
| eval test3=replace(test,"[^\w]","_")
| eval test2=$test$

The token looks OK,
If necessary, convert it?

Re: How to use value from a drop down that contains reserved characters in a search?

robert_adams — Thu, 05 Mar 2020 21:11:31 GMT

Unfortunately it still came back with no data when I quoted the token and errors when I didn't. I finally got it to work by using the hash for the error message. Thanks.