Splunk Search

Dropdown Not Populating

CannonT
Engager

I'm trying to populate a dropdown box with this search which returns the values I would expect, but the dropdown is not populating. I have also tried using inputlookup to populate directly from the csv to no avail.

index=test_index sourcetype=recipients OR sourcetype=opened OR sourcetype=submitted  
    | lookup list.csv identity AS userID OUTPUT bunit as bunit company AS Location  
    | rename FN as "First Name" LN as "Last Name" 
    | lookup BusinessUnit.csv bunit AS bunit OUTPUT "Corporate Division" AS "cdiv" 
    | stats count by cdiv

This is my dropdown

<input type="dropdown" token="Corporate Division">
      <label>Coporate Division Selection</label>
      <selectFirstChoice>true</selectFirstChoice>
      <populatingSearch fieldForLabel="Coporate Division" fieldForValue="Coporate Division">
      <![CDATA[index=test_index sourcetype=recipients OR sourcetype=opened OR sourcetype=submitted | lookup list.csv identity AS userID OUTPUT bunit as bunit company AS Location | rename FN as "First Name" LN as "Last Name" | lookup BusinessUnit.csv bunit AS bunit OUTPUT "Corporate Division" AS "cdiv" | stats count by cdiv]]>
      </populatingSearch>
      <choice value="*" selected="true">All Division</choice>
      <default>*</default>
    </input>
0 Karma
1 Solution

somesoni2
Revered Legend

From your search query, the output fields are "count" and "cdiv" only (after stats) and you're trying to use the fields "Coporate Division" in the dropdown, which doesn't exists. Try using the field name "cdiv" in the dropdown properties (fieldForLabel and fieldForValue).

<input type="dropdown" token="Corporate Division">
      <label>Coporate Division Selection</label>
      <selectFirstChoice>true</selectFirstChoice>
      <populatingSearch fieldForLabel="cdiv" fieldForValue="cdiv">
      <![CDATA[index=test_index sourcetype=recipients OR sourcetype=opened OR sourcetype=submitted | lookup list.csv identity AS userID OUTPUT bunit as bunit company AS Location | rename FN as "First Name" LN as "Last Name" | lookup BusinessUnit.csv bunit AS bunit OUTPUT "Corporate Division" AS "cdiv" | stats count by cdiv]]>
      </populatingSearch>
      <choice value="*" selected="true">All Division</choice>
      <default>*</default>
    </input>

View solution in original post

somesoni2
Revered Legend

From your search query, the output fields are "count" and "cdiv" only (after stats) and you're trying to use the fields "Coporate Division" in the dropdown, which doesn't exists. Try using the field name "cdiv" in the dropdown properties (fieldForLabel and fieldForValue).

<input type="dropdown" token="Corporate Division">
      <label>Coporate Division Selection</label>
      <selectFirstChoice>true</selectFirstChoice>
      <populatingSearch fieldForLabel="cdiv" fieldForValue="cdiv">
      <![CDATA[index=test_index sourcetype=recipients OR sourcetype=opened OR sourcetype=submitted | lookup list.csv identity AS userID OUTPUT bunit as bunit company AS Location | rename FN as "First Name" LN as "Last Name" | lookup BusinessUnit.csv bunit AS bunit OUTPUT "Corporate Division" AS "cdiv" | stats count by cdiv]]>
      </populatingSearch>
      <choice value="*" selected="true">All Division</choice>
      <default>*</default>
    </input>
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...