topic Re: Why my dropdown input create an empty value? in Dashboards & Visualizations

Why my dropdown input create an empty value?

mah — Thu, 31 Dec 2020 15:09:40 GMT

Hi,

I have a weird reaction of my dropdown input :

It seems the input create a empty value in the dropdown choice whereas when I run the input request, the result is giving just ID list :

Here is my xml code :

<row>
<panel>
<title>ID list</title>
<input type="dropdown" token="id_tok" searchWhenChanged="true">
<label>Select an ID to delete</label>
<fieldForLabel>id</fieldForLabel>
<fieldForValue>id</fieldForValue>
<search>
<query>| inputlookup id_list.csv
| fields id
| dedup id</query>
<earliest>-1m@m</earliest>
<latest>now</latest>
</search>
<prefix>"</prefix>
<suffix>"</suffix>
</input>
<table>
<search>
<query>| makeresults 
| eval ID=$id_tok$
| fields - _time
| dedup ID
| outputlookup append=t id_delete.csv</query>
<earliest>-1m</earliest>
<latest>now</latest>
<sampleRatio>1</sampleRatio>
<refresh>1m</refresh>
<refreshType>delay</refreshType>
</search>
<option name="count">20</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">none</option>
<option name="percentagesRow">false</option>
<option name="refresh.display">progressbar</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
</table>
</panel>
</row>

Beside, my panel request does not seem to work : " Error in 'eval' command: Failed to parse the provided arguments. Usage: eval dest_key = expression."

The fact is that when I open the search, the token value is not set... :

Can you help me ?

Thanks !

Re: Why my dropdown input create an empty value?

to4kawa — Thu, 31 Dec 2020 15:29:39 GMT

<row> <panel> <title>ID list</title> <input type="dropdown" token="id_tok" searchWhenChanged="true"> <label>Select an ID to delete</label> <fieldForLabel>name</fieldForLabel> <fieldForValue>id</fieldForValue> <search> <query>| inputlookup id_list.csv | fields id | dedup id |eval name=substr(id,1,4)</query> <earliest>-1m@m</earliest> <latest>now</latest> </search> <prefix>"</prefix> <suffix>"</suffix> </input> <table> <search> <query>| makeresults | eval ID=$id_tok$ | fields - _time | dedup ID | outputlookup append=t id_delete.csv</query> <earliest>-1m</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> <refresh>1m</refresh> <refreshType>delay</refreshType> </search> </table> </panel> </row>

Dropdown should have a separate name and value.

Re: Why my dropdown input create an empty value?

mah — Thu, 31 Dec 2020 15:53:06 GMT

Hi @to4kawa

I apply your code but it gives me this :

In the above panel I table all ids, and with this settings :

<fieldForLabel>name</fieldForLabel>
<fieldForValue>id</fieldForValue>

I get "name" values and not "id" values ...