I only know how to do this in advanced XML.
First, you will have to schedule the saved search and make it visible to the app that you have created the report/dashboard in. Once you have it scheduled, make sure it runs once before you go to the dashboard.
In the dashboard XML file, add something to this effect in the appropriate location:
<module name="HiddenSavedSearch">
<param name="savedSearch>your saved search name here</param>
<param name="useHistory">true</param>
The rest of your modules will go here
</module>
If you want the query to run as someone loads the page then it will be more like this:
<module name="SavedSearch" autoRun="True">
<param name="savedSearch>your saved search name here</param>
The rest of your modules will go here
</module>
Make sure that the saved search that you create looks like this:
| dbquery "select * FROM your_database.your_table" | any other stuff here...
It is very important that there is a pipe before dbquery or it will not work. Just FYI, I have had issues with putting "|" in macros and saved searches. It might be an issue with having the pipe in the saved searches. You may also not have the dbx modules needed shared with the proper app.
If none of these work for you, let me know.
... View more