Is there a table of BAQs? I want to create a BAQ search that displays the BAQQs and their date created.
1 Like
QueryHdr
Thanks. I did not however see the date created as a field. Could it be that it’s in another table?
Dear Randall,
After you drag the table Ice.QueryHdr onto the design area, go back above the tree view and delete your typing in the box and just below that click the little link symbol. Not the one above the design area but between the search box and the table list. At this point the table list changes to a list of all tables Epicor KNOWS are linkable to QueryHdr although there may be others. Drag any of these into the field and refer to the field area (hint: open in Excel for searchability!)
At least as of version 10.1.600 the cute little “link” symbol changes to a plain white box for some reason, when it’s clicked. But it appears to work OK.
HTH
…Monty.
I’m not sure how it is in Epicor 10, but in Epicor 9 I ended up making a Data Directive for the “Exports” table (looks like it might be called "QueryHdr for you?) that sets a particular Date field to the current date if the field is currently unused.
Thanks Monty. However the dated created/modified was not in any of the linkable tables 
It won’t be, as @kalbee suggests you will need to add a UD column to QueryHdr then with a BPM set the date.
What’s the use case?
Randall, since no “creation date” exists in any of the BAQ tables, you may want to look into a UD date field or change log.
Yes thanks. I am rusty at that but will persist.
Randy