Query of BAQs and related Dashboards

Epicor ERP 9
1

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

2

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

3

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?

4

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

5

Lucky you :slight_smile:

6

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.

7

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

8

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

9

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.