topic Re: pass quotes inside of tokens for dashboard in Dashboards & Visualizations

pass quotes inside of tokens for dashboard

johnmvang — Wed, 07 Nov 2018 17:49:44 GMT

Hello,

I'm looking to pass a token in a dashboard where the value may have quotes, since the token is going into an eval, anyone know how to get that to work? Right now i'm running into eval malformed errors. with quadruple quotes or more depending on how many quotes the user inputs.

Thanks.

Re: pass quotes inside of tokens for dashboard

Vijeta — Mon, 26 Nov 2018 21:17:16 GMT

Can you post some example values for tokens and the code which is giving error

Re: pass quotes inside of tokens for dashboard

johnmvang — Tue, 29 Sep 2020 22:07:58 GMT

sure,

i've got a dashboard, where users can fill out 3 forms:

they can input:

'My Title' for input1 - which is a title input.
index="my_index" sourcetype="my_sourcetype" my_search - for the search
then choose a dropdown.

 <panel depends="$show_row2_tok$,$show_r2panel2_tok$">
      <title>Row 2 - Panel 2</title>
      <input type="text" token="r2p2_title">
        <label>Panel Title</label>
        <default></default>
      </input>
      <input type="text" token="r2p2_search">
        <label>Search String</label>
        <default></default>
      </input>
      <input type="dropdown" token="r2p2_viz">
        <label>Visualization Type</label>
        <choice value="column">Column Chart</choice>
        <choice value="line">Line Graph</choice>
        <choice value="stats">Stats Table</choice>
        <default></default>
      </input>
      <html>

    </html>
    </panel>

These will then populate values in a KVstore where i need to write them with an eval:

since i'm enabling users to add a search string into the second input, sometimes they will have quotes inside of their values which will break the search with this error:

Error in 'eval' command: The expression is malformed.

Re: pass quotes inside of tokens for dashboard

johnmvang — Mon, 26 Nov 2018 22:18:04 GMT

this all works as long as there are no quotes. just fyi.

Re: pass quotes inside of tokens for dashboard

kamlesh_vaghela — Tue, 27 Nov 2018 12:18:43 GMT

@johnmvang
You can escape quote by replacing " to \" on change of input. Just try to insert "ABC" in below provided sample dashboard XML.

<form>
  <label>Quotes</label>
  <fieldset submitButton="false">
    <input type="text" token="field1">
      <label>field1</label>
      <change>
        <eval token="txtValue">replace('value',"\"","\\\"")</eval>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <title>
        $txtValue$
      </title>
      <table>
        <search>
          <query>| stats count | eval A="$txtValue$"</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</form>

Re: pass quotes inside of tokens for dashboard

johnmvang — Wed, 28 Nov 2018 14:30:36 GMT

Hi Kamlesh, that did it for me. Thanks works great.

Re: pass quotes inside of tokens for dashboard

kamlesh_vaghela — Wed, 28 Nov 2018 16:28:51 GMT

Glad to help you @johnmvang
Can you please accept the answer to help the community?

Re: pass quotes inside of tokens for dashboard

vasanthi77 — Fri, 28 Jun 2019 04:16:12 GMT

Hi Kamlesh ,
I had the same problem, was trying the solution provided by you here.
I could see only first occurence is getting replaced.
Can Please you help me here