How do I get each unique value for a field to appear in a drop-down list?

[brutecat]

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?

[gyslainlatsa · Accepted solution]

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

[brutecat]

gyslainlatsa,

Thanks so much. I thought I had tried this. The behaviour of 'values' does not seem consistent here.

Anyway, thanks again,

Stan

[gyslainlatsa]

Your are welcome, don't forget to vote my answers