topic Using dbquery in dashboard forms - help in Dashboards & Visualizations

Using dbquery in dashboard forms - help

ericrobinson — Mon, 28 Sep 2020 14:06:50 GMT

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.ASET_AMT, A.ID_C FROM ASAP.test A WHERE a.aset_test_id_c = (SELECT A.ASET_test_ID_C FROM ASAP.ACCOUNT A WHERE A.TEST_INSTN_ID_N=$testid$)"

The form is giving this..

search dbquery "Database - PROD" limit=1000 "SELECT A.ASET_AMT, A.ID_C FROM ASAP.test A WHERE a.aset_test_id_c = (SELECT A.ASET_test_ID_C FROM ASAP.ACCOUNT A WHERE A.TEST_INSTN_ID_N=$testid$)"

and that is NOT returning results.

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

Re: Using dbquery in dashboard forms - help

ericrobinson — Mon, 17 Jun 2013 17:25:29 GMT

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?

Re: Using dbquery in dashboard forms - help

ericrobinson — Mon, 17 Jun 2013 18:24:37 GMT

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

Re: Using dbquery in dashboard forms - help

sowings — Tue, 17 Sep 2013 16:39:11 GMT

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.