I have a BAQ report that is run everyday that I’d like to schedule to run every night. The thing is,it has a date as an input parameter. How can I schedule and run it so that the date it is run is the date used?
If I change the date field of the BAQ Report window to be Dynamic, and set it to ‘Today’, and schedule it to run daily, won’t it just use the same date (the date when it was first scheduled) for subsequent days?
You need to change the BAQ’s select criteria. We use this below in one of
our BAQs. Then we scheduled the BAQ Export to run on a schedule.
[image: pasted1]
Thanks. Can you re-paste the image. All I see is:
[image: pasted1]
Sure,
In this example, it’s ChangeDate (first date field on the list), just set the Filter Value to “Current Date + Specified Interval” option. Then select Days/Weeks/Months/Years and go forward and backward (negative numbers) by those intervals. In the example it’s -1 Day.
You could also use “BAQ special Constant”. We sometimes have to run our BAQ for more than “yesterday” so we use the first option but this could work for your needs as well.
So you have two nearly identical BAQ’s?
One that users launch and can select the date.
And one that you schedule (which uses a hardcoded dynamic date)?
No, I was just showing both options for you. We use the first one I
mentioned, with the -1 Day, not the BAQ Constant for troubleshooting
reasons. Our users don’t have to run this BAQ at all.
If for some reason --system maintenance, data connection issues, etc-- the
scheduled BAQ Export doesn’t work, we’ll need to go back more than one day.
So we manually change the criteria and run the query. But that’s rare and
only when needed, so we do it here in IT.
Hi,
I have an updatable BAQ which has a custom code. We are in public cloud, Need to run this code 4am and 7.30pm everyday. How to schedule it?
This BAQ is about auto clocking out the employees who logged in more than 14hours.
Thanks
Subha
I think you’d want to look at a BPM to do that type of automation.
