Hi Guys,
I got my query right and I see my values properly populate on the dropdown input. However, I cant pass this token to populate my query on to the next query. Is there something wrong with my xml?
<input type="dropdown" token="sourceName" searchWhenChanged="true">
<label>Select SourceName</label>
<choice value="*">All</choice>
<default>*</default>
<fieldForLabel>sourcename</fieldForLabel>
<fieldForValue>sourcename</fieldForValue>
<search>
<query>index="example_of_idx" sourcename=Service_Requested OR sourcename=Service_Suggested | stats count by sourcename | replace Service_Requested WITH "Type of Service" Service_Suggested WITH "Type of Service Suggested" IN sourcename | table sourcename </query>
</search>
</input>
Your query search seems to only return two values "Service_Requested" and "Service_Suggested" (assuming they exist in example_of_idx), which you then replace with phrases with embedded spaces. If you are using these values (with embedded spaces), are you protecting the spaces e.g. do you use the token filter |s to wrap the token value in quotes? Also, do you actually want the replacement string passed or is that really just for the dropdown? If it is for the dropdown, you should do something like this:
<input type="dropdown" token="sourceName" searchWhenChanged="true">
<label>Select SourceName</label>
<choice value="*">All</choice>
<default>*</default>
<fieldForLabel>label</fieldForLabel>
<fieldForValue>sourcename</fieldForValue>
<search>
<query>index="example_of_idx" sourcename=Service_Requested OR sourcename=Service_Suggested | stats count by sourcename | eval label=sourcename | replace Service_Requested WITH "Type of Service" Service_Suggested WITH "Type of Service Suggested" IN label | table sourcename label</query>
</search>
</input>
Your query search seems to only return two values "Service_Requested" and "Service_Suggested" (assuming they exist in example_of_idx), which you then replace with phrases with embedded spaces. If you are using these values (with embedded spaces), are you protecting the spaces e.g. do you use the token filter |s to wrap the token value in quotes? Also, do you actually want the replacement string passed or is that really just for the dropdown? If it is for the dropdown, you should do something like this:
<input type="dropdown" token="sourceName" searchWhenChanged="true">
<label>Select SourceName</label>
<choice value="*">All</choice>
<default>*</default>
<fieldForLabel>label</fieldForLabel>
<fieldForValue>sourcename</fieldForValue>
<search>
<query>index="example_of_idx" sourcename=Service_Requested OR sourcename=Service_Suggested | stats count by sourcename | eval label=sourcename | replace Service_Requested WITH "Type of Service" Service_Suggested WITH "Type of Service Suggested" IN label | table sourcename label</query>
</search>
</input>
Thanks! @ITWhisperer the eval command did fixed the problem.