Get a list of all BAQs

Epicor ERP 10
,
1

I would like to get a list of all BAQs with author, name, etc. Anyone knows which table contains those info and I should query from? Thanks,

2

Ice.QueryHdr

3

Thank you very much. Is there any table showing when a baq was run last time?

4

Not to my knowledge.

5

or what time a baq was created.

6

No that would also be some custom functionality you’d have to build, to my knowledge.

7

Thank you a lot, Aaron. Happy Thanksgiving!

1 Like
8

You too!

9

Already have these, may as well share them, right?
FSIP-BAQs.baq (16.8 KB) FSIP-QueryTables.baq (17.4 KB) FSIP-QueryTablesWithField.baq (19.9 KB) FSIP-QueryPhrases.baq (12.2 KB)

4 Likes
10

There is currently no way to tell when the last time a BAQ was used… but this may be getting even more difficult because BAQs are used in so many ways. QuickSearch, Dashboards, Reports were originally the only uses, but now they populate combo boxes, used in Product configurators, used by XLConnect, the UI, Kinetic, etc etc etc… Not sure if there is a plan to keep track of every time a BAQ is touched/used.

1 Like
11

You can add a BPM on Method DynamicQuery.GetQueryByID and then log query name and date to a UD table. This provide a pretty good way of monitoring usage but I assume you want history from before so this might be old news.
You can also enable change logs on the QueryHdr table using an old tip that was posted on this site about modifying zDataTable.