As much as I have tried every variant in the potential answers, I can't make this work. I have the following code:
<input type="dropdown" token="machine_tok" searchWhenChanged="true">
<label>Select a machine</label>
<prefix>Machine_Name="</prefix>
<suffix>"</suffix>
<choice value="*">ND001913</choice>
<default>ND001913</default>
<search>
<query>index=nextgen_machine | stats values(Machine_Name) as machines</query>
</search>
<fieldForLabel>machine</fieldForLabel>
<fieldForValue>machine</fieldForValue>
</input>
Which displays the default value of ND001913. The other values are found, but presented as a comma delimited list as only one single other value. How to I get this to return one item in the drop-down for one unique value?
hi,
Do not use values()
try like this
<input type="dropdown" token="machine_tok" searchWhenChanged="true">
<label>Select a machine</label>
<prefix>Machine_Name="</prefix>
<suffix>"</suffix>
<choice value="*">ND001913</choice>
<default>ND001913</default>
<search>
<query>index=nextgen_machine | stats count by Machine_Name </query>
</search>
<fieldForLabel>Machine_Name</fieldForLabel>
<fieldForValue>Machine_Name</fieldForValue>
</input>
if the field name in your events is rather machine
instead of Machine_Name
, must be replaced Machine_Name
by machine
hi,
Do not use values()
try like this
<input type="dropdown" token="machine_tok" searchWhenChanged="true">
<label>Select a machine</label>
<prefix>Machine_Name="</prefix>
<suffix>"</suffix>
<choice value="*">ND001913</choice>
<default>ND001913</default>
<search>
<query>index=nextgen_machine | stats count by Machine_Name </query>
</search>
<fieldForLabel>Machine_Name</fieldForLabel>
<fieldForValue>Machine_Name</fieldForValue>
</input>
if the field name in your events is rather machine
instead of Machine_Name
, must be replaced Machine_Name
by machine
gyslainlatsa,
Thanks so much. I thought I had tried this. The behaviour of 'values' does not seem consistent here.
Anyway, thanks again,
Stan
Your are welcome, don't forget to vote my answers