Dashboards & Visualizations
Highlighted

Using dbquery in dashboard forms - help

Path Finder

Hello, I am seeing an issue where I cannot see results when trying to use dbquery in a dashboard. It as pre-pending a "search" onto the search and its not finding any results.

My search normally is this and returns results..

| dbquery "Database - PROD" limit=1000 "SELECT A.ASETAMT, A.IDC FROM ASAP.test A WHERE a.asettestidc = (SELECT A.ASETtestIDC FROM ASAP.ACCOUNT A WHERE A.TESTINSTNIDN=$testid$)"<!-- AND a.testdtd="$enddate$" -->

The form is giving this..

search dbquery "Database - PROD" limit=1000 "SELECT A.ASETAMT, A.IDC FROM ASAP.test A WHERE a.asettestidc = (SELECT A.ASETtestIDC FROM ASAP.ACCOUNT A WHERE A.TESTINSTNIDN=$testid$)"<!-- AND a.testdtd="$enddate$" -->

and that is NOT returning results.

Is there a preferred way to use dbquery in these forms?

Tags (2)
0 Karma
Highlighted

Re: Using dbquery in dashboard forms - help

Path Finder

It looks like its not because of the extra "search" search string.. Instead, it looks like it is missing the pipe in the searchtemplate in the form, and therefore the dbquery command is not working as its not recognized as a command

Any idea on how to make the | stick and continue to the underlying search being run?

0 Karma
Highlighted

Re: Using dbquery in dashboard forms - help

Path Finder

I think I figured this out.. problem was with not using the CDATA tags, and the leading space.

View solution in original post

0 Karma
Highlighted

Re: Using dbquery in dashboard forms - help

Splunk Employee
Splunk Employee

Can your provide a sample of what you were able to get working? I'm facing a similar issue using one of those "must be the first command after a pipe" search commands in a searchTemplate in a dashboard.

0 Karma