Query of BAQs and related Dashboards

I want to make a query of all BAQs and their related dashboards - a where used query. The field help in a BAQ says the table is Exports, but that table does not contain all of the BAQS we have. Is thee a different table containing BAQs?

What I want to see is all BAQs and related dashboards if using an outer join any:

BAQ…DB
ABC…ABC
Sales…null

QueryHdr Holds the BAQs, DashBdBAQ holds the BAQ’s used by the Dashboard

QueryHdr.QueryID = DashBdBAQ.QueryID

Edit:

And BAQ Reports use table BAQReport

BAQReport.BAQRptID is the BAQ Report’s ID
BAQReport.ExportID is the ID of the BAQ used by the Report

Thanks that worked great in E10, but the tables are not there in E9. I want to get E9 data as we are upgrading to E10 October 1st. Do you know the E9 tables?

Can’t help you there. We jumped straight from V8 to E10

Lucky you :slight_smile:

We didn’t do a conversion, but rather a virgin install of E10, exported select records (parts, customers, BOMs, etc…) and used DMT to setup and seed E10.

Learned lots of lessons the hard way. Especially regarding UOMs.

Get cirrus analyzer is free and it will have all this info

Got a link for that @josecgomez? Mr Google is not being very helpful this morning :grin:

In E9 the table DashBdBAQ holds BAQ to dashboard links. Exports is the BAQ table, not sure why yours doesn’t show all BAQs. Are you multi-company? If so, your BAQ on the Exports table needs to be cross-company.