BAQ Hours Timeframe criteria

Hey Folks,

I am looking to make a BAQ that shows new Orders three times a day, but does not include what was sent on the previous report. For example, if I wanted to have this report export 3 times a day (every 8 hours), the 2nd report won’t have on it the Orders from the 1st report and the 3rd report won’t have on it any Orders from the 1st and 2nd report.

Basically, what I need is a way to add a criteria to run for less than a day. Preferably every 8 hours. Right now all I can see for criteria is by Day, Week, Month or Year.

Any suggestions?

In Advanced BPM processing do this abl code in Postprocessing of the getlist mark the order as processed. Then exclude that checkbox in the criteria, so they won’t show in the next run.

for each ttResults.

            ttResults.OrderHed_CheckboxXX = true.

End

Hey Greg,

Thanks for the help. When I do this it is giving me an error. What am I doing wrong? I chose BAQDesigner.GetList

This is done in the BAQ Designer. Make the BAQ updatable, and set your checkbox as updatable. Click Regenerate BPM Directive.

Click on Advanced BPM processing and add the routine as post processing under GetList. Pick ABL code and put the routine there.

When getlist is clicked ( refresh in a dashboard ) the bpm will run.

[cid:image003.png@01D23446.77E92990]

[cid:image004.png@01D23446.77E92990]

Oh ok, let me try that. My bad

Hey Greg,

I am getting this error when I click on Regenerate BPM Directive. I have deploy the Dashboard, but the orders are showing up each time it runs so the BPM is obviously not working.

Your update tab should look like below. UpdateExt is the normal update method. Just check ttOrderHed.

As I made the example I realized that someone would have to save the results to update the order and not just the dashboard.

Change getlist to something like this.

For Each ttResults exclusive-lock.

                                            ttResults.orderhed_checkbox20 = true.

            For each Orderhed where company=cur-comp and ttResults.OrderHed_OrderNum = OrderHed.Ordernum exclusive-lock.

                            OrderHed.checkbox20 = true.

            End.

End.

[cid:image001.png@01D23464.A8861860]

Greg,

Again, I want to thank you for all the help.

I did everything above, but the dashboard is still showing all records each time I run it. Not sure what is wrong, but I don’t have a condition in the GetList BPM screen. Could that be the reason?

Are you checking for the checkbox to be false in the criteria? Do you have the checkbox in the results to see if it has been set?

Greg

[cid:image001.png@01D2355C.301FA7D0]

Call me a moron. Man, I really appreciate the help on this. This is going to completely cut out any manual (human) interaction now for my project. Thanks again!

Greg,

The BPM works great when I run it from the BAQ Designer, but I have the BAQ exporting from the BAQ Export function that I scheduled under the System Agent. The BPM doesn’t seem to work when it exports from the Schedule. Is that common or is there something I need to do?

I am pretty sure the export doesn’t call GetList… try putting a BPM on Execute By ID in the DynamicQueryAdapter

Jose,
I will try that.