I am trying to set up a dropdown on over 90000 unique values. But all the values are not coming in the dropdown. why this is happening? Are there any limitations?
Even if it was working, it would be functionally useless. When we have to do this kind of thing, we institute a pre-filter
like this (here we are searching for server names) which cuts down the actual list to a manageable level.
<input type="text" token="server_name_partial" searchWhenChanged="false">
<label>RegEx filter for Server Dropdown --></label>
<default>.</default>
</input>
<input type="dropdown" token="server_name" searchWhenChanged="false">
<label>(<-- filtered) Server Selector:</label>
<default>*</default>
<choice value="*">All</choice>
<fieldForLabel>server_name</fieldForLabel>
<fieldForValue>server_name</fieldForValue>
<search>
<query>| inputcsv servernamelist.csv | regex server_name="(?i)$server_name_partial$" | table server_name</query>
<earliest>-1s</earliest>
<latest>now</latest>
</search>
</input>
Unsure if there is a max limit to the dropdown.
There is one way to test this out.
1) Write the current list of unique values to a lookup table
index=test
| stats count by Unique_values
| outputlookup Unique_values.csv
2) now create the dropdown
| inputlookup Unique_values.csv
| fields Unique_values
This overcomes any issues that could be happening due to slow search output or any other performance hit. If it populates all values, job done, otherwise there might be a newly discovered feature (limit on dropdown values).