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!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...