Using dbquery in dashboard forms - help

[ericrobinson]

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$)"<!-- AND a.test_dt_d="$end_date$" -->

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 a.test_dt_d="$end_date$" -->

and that is NOT returning results.

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

[ericrobinson · Accepted solution]

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

[sowings]

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.

[ericrobinson]

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?