topic Dropdown values are not shown in Dashboards & Visualizations

Dropdown values are not shown

SrinivasaC — Mon, 28 Sep 2020 13:29:10 GMT

My sample file:

State , District , Total Enrolments

Andaman_and_Nicobar_Islands, Andamans,116866>

Andaman_and_Nicobar_Islands, Port_Blair,2

Andhra_Pradesh, Hyderabad,5004246

Andhra_Pradesh, Ananthapur,92

Arunachal_Pradesh, West_Kameng,143

Arunachal_Pradesh, Lohit,77

I have to get State values in dropdown based on selection, District and enrol values have to show.

My advanced XML form shown below:

<?xml version='1.0' encoding='utf-8'?>

Dropdown List For States

<!-- define master search template, with replacement tokens delimited with $ -->
<searchTemplate>index="states_index" series=$series$ | table "District", "Total_Enrolments"</searchTemplate>

<fieldset>
    <!-- Define a simple dropdown form driven by a search -->
    <input type="dropdown" token="series">
        <label>Select State</label>
        <populatingSearch fieldForValue="series" fieldForLabel="series"><![CDATA[index="states_index"  | dedup State | table State | sort +State]]></populatingSearch>
        <choice value="*">Any</choice>
    </input>
</fieldset>

<row>
    <!-- output the results as a 50 row events table -->
    <table>
        <title>Matching events</title>
        <option name="count">50</option>
    </table>
</row>

Re: Dropdown values are not shown

martin_mueller — Sat, 09 Mar 2013 23:22:40 GMT

That doesn't look like Advanced XML to me, see http://docs.splunk.com/Documentation/Splunk/latest/AdvancedDev/AdvancedFormSearch

Re: Dropdown values are not shown

SrinivasaC — Sun, 10 Mar 2013 04:16:57 GMT

Im Sorry Im working on forms.
Thanks Martin,
I have followed as example given in the Splunk UI Examples(form_dropdown.xml).

Re: Dropdown values are not shown

SrinivasaC — Sun, 10 Mar 2013 06:45:21 GMT

I can able to get results when I click on search button. but in dropdown, I'm unable to retrieve States.

Re: Dropdown values are not shown

sideview — Sun, 10 Mar 2013 17:02:47 GMT

You've left a few things in the XML set to the values from the example, .

The examples all use a "series" field, whereas here you want it to pull from a field called "State".

You've got series=$series$ in your search, when you want to have State="$State$.

You also have token=series, which is what tells the system you want to use $series$ in your searches to identify the token. You want to change that to token="State"

You then have fieldForValue="series" fieldForLabel="series". This tells the dropdown to look for it's values in a field called series, which of course wont be there. Change those both to be State.

Re: Dropdown values are not shown

SrinivasaC — Mon, 11 Mar 2013 04:34:19 GMT

Thanks sideview