https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147723#M8998 <P>Hello Everyone,<BR /> I have the following simple xml code but nothing is appearing in the dropdown. Please help me with the code.<BR /> </P><FORM><BR /> <SEARCHTEMPLATE> | dbquery "Finance Database" "select book_type_code from fa_deprn_periods" book_type_code=$book_type_code$ | fields book_type_code</SEARCHTEMPLATE><BR /> <FIELDSET><BR /> <INPUT type="dropdown" token="book_type_code" /><BR /> <LABEL>Select series</LABEL><BR /> <POPULATINGSEARCH fieldforvalue="book_type_code" fieldforlabel="book_type_code">&lt;![CDATA[ | dbquery "Finance Database" "select book_type_code from fa_deprn_periods"]]&gt;</POPULATINGSEARCH><BR /> <CHOICE value="*">Any</CHOICE><BR /> <BR /> </FIELDSET><BR /> </FORM><P></P> <P>Thanks in advance</P> Mon, 28 Sep 2020 15:52:30 GMT vikas_gopal 2020-09-28T15:52:30Z https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147723#M8998 <P>Hello Everyone,<BR /> I have the following simple xml code but nothing is appearing in the dropdown. Please help me with the code.<BR /> </P><FORM><BR /> <SEARCHTEMPLATE> | dbquery "Finance Database" "select book_type_code from fa_deprn_periods" book_type_code=$book_type_code$ | fields book_type_code</SEARCHTEMPLATE><BR /> <FIELDSET><BR /> <INPUT type="dropdown" token="book_type_code" /><BR /> <LABEL>Select series</LABEL><BR /> <POPULATINGSEARCH fieldforvalue="book_type_code" fieldforlabel="book_type_code">&lt;![CDATA[ | dbquery "Finance Database" "select book_type_code from fa_deprn_periods"]]&gt;</POPULATINGSEARCH><BR /> <CHOICE value="*">Any</CHOICE><BR /> <BR /> </FIELDSET><BR /> </FORM><P></P> <P>Thanks in advance</P> Mon, 28 Sep 2020 15:52:30 GMT https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147723#M8998 vikas_gopal 2020-09-28T15:52:30Z https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147724#M8999 <P>Please help...any solution..?</P> Wed, 12 Feb 2014 14:17:48 GMT https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147724#M8999 vikas_gopal 2014-02-12T14:17:48Z https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147725#M9000 <P>Finally I crack this and i did not believe it was just a silly mistake. I just mentioned field name in "" in the dbquery which is "bookcode".So keep this in mind whatever you are mentioning in the fieldforvalue and fieldforlable should be similar to ur field name in dbquery that is it.<BR /> here is my code </P> <P><FIELDSET><BR /> &lt;!-- Define a simple dropdown form driven by a search --&gt;<BR /> <INPUT type="dropdown" token="bookcode" /><BR /> <LABEL>Select series</LABEL><BR /> <POPULATINGSEARCH fieldforvalue="bookcode" fieldforlabel="bookcode"><BR /> &lt;![CDATA[| dbquery "Finance Database" "select distinct book_type_code "bookcode" from fa_deprn_periods where period_name='JAN-09' and book_type_code='CORPORATE USA'" ]]&gt;</POPULATINGSEARCH><BR /> <BR /> </FIELDSET></P> Mon, 28 Sep 2020 15:52:51 GMT https://community.splunk.com/t5/Dashboards-Visualizations/cannot-get-result-in-dropdown/m-p/147725#M9000 vikas_gopal 2020-09-28T15:52:51Z