Hey everyone,
Is there a way to see the last time a baq was executed in the system? And the last time a dashboard was opened and by who?
1 Like
If you don’t need a full running log, you could add UD fields to the table QueryHdr ( a datetime and nvchar for the user)
and then in a BPM update those fields.
This would be a great feature for admins to help determine what to purge during upgrades…
6 Likes
And for admins to determine which dashboard the user really did run.
It’s amazing how often the “problem” turns out that the user was running a different dashboard or report style.
2 Likes
I have a BPM on DynamicQuery.ExecuteQuery which stores data into UD25. I picked up the code from either e10help or the EUG forum.
2 Likes
agreeded. Maybe a vote to take to Epicor. I have Dashboards that people swear they need but I can’t tell if they are really using them
1 Like
Can you share this? Also can this be easily changed for E9? I need to know what is really being used in E9.
Last Run
Yes… this was (is) a feature in Dataworks, an earlier product of Epicors.
It was very handy for an admin to be able to know the “last used by” date/person.
So the BAQ won’t work if I export it from E10 - I’ll post the steps:
In E9, the highlighted field is called something different. Something like “Delivered” rather than SystemFlag.
The screenshots are a tad busy, buy should be enough you for to recreate in E9.
2 Likes
The exported BAQ will work for those of us on E10 
Where did you find the BAQ? I didn’t see an attachment in this string.
In case you dont want to store a log and use up a UD table, I made a variation of the post processing ExecuteQuery directive. It just writes a timestamp of “now” to the queryHdr table on a custom UD field. I needed to use the BAQReportDesigner methods to write this date BAQLastExecTime.bpm (31.8 KB)
1 Like
Hi there, I have been trying to get this working in E9 but not having much luck with the method.
Does anyone have a the files i can import for E9 please.
Is there a exported BAQ for Epicor 9.5
I don’t have access to an E9 system any longer - what errors/issues are you having?
What options are available to you in the dropdown list?
So you want the one that says:
numbers of rows in the designed query is
Then you need to click on the “designed” hyperlink, and make it match what I have in the above screenshot.