topic Re: database field value in dropdown in Dashboards & Visualizations

database field value in dropdown

vikas_gopal — Mon, 10 Feb 2014 18:16:11 GMT

Hi Guys,

I have a DBquery "select distinct open_date from ABC" .I want to show these dates in dropdown list .Please suggest how to do it..

Regards
Vikas

Re: database field value in dropdown

theouhuios — Mon, 10 Feb 2014 18:54:33 GMT

Where do you want to show these dates? In a dashboard? You will have to pull the data in first to be able to do that. Please add some more information on what you plan to do.

Re: database field value in dropdown

somesoni2 — Mon, 10 Feb 2014 19:17:18 GMT

See Splunk documentation for how a search can be used to populate dropdown.
Splunk 6.x - http://docs.splunk.com/Documentation/Splunk/latest/Viz/PanelreferenceforSimplifiedXML#dropdown

Re: database field value in dropdown

vikas_gopal — Tue, 11 Feb 2014 09:47:22 GMT

Thanks Theouhuios

Actually I am preparing a dashboard which takes input from oracle database and I want to show date field in dropdown, user will select one date from the dropdown list and on the basis of that dashboard table shows data.

Re: database field value in dropdown

vikas_gopal — Thu, 13 Feb 2014 11:50:07 GMT

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 "opendate".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.
here is my code

Select series

<![CDATA[| dbquery "Finance Database" "select distinct open_date "opendate" from ABC" ]]>

Re: database field value in dropdown

vikas_gopal — Thu, 13 Feb 2014 13:21:21 GMT

I found another solution for this . Using Lookup you can achieve the same.
follow the following steps
1) Create a csv file in the following location "Splunk home\etc\apps\dbx\lookups lets say the file is "user.csv".Make sure u must have some data in the CSV file.Else if u chk my code I am creating a CSV from dbquery with the help of | outputlookup command.
2) Create a new lookup from Settings--->Lookups-->Lookup table file here select the same csv file which u have created u can choose the same file name in the destination lets say the name is "vikaslookup".
3) Make sure u chkd the permissions it should be global.
4) Now open splunk and type the following code and that is it.

| dbquery "your database" "select abcdate as "Fromdate" from help"| outputlookup user.csv

<![CDATA[ | inputlookup vikaslookup ]]>

2013