Misspending my youth on an External BAQ using Dynamic Query in a Data Directive, only works where Appserver and Database share a machine

[gpayne (Greg Payne)]

@SteveFossey I think a scheduled UBAQ would work for this. My initial query results are typically what I work with, but you could have a query on a 1 row UD table and then do anything from there. The bpm(s) are post processing on GetList.

Example of three calculations on ttResults

Add a schedule to system agent
Set a BAQ Export process of your UBAQ on your schedule.

EDIT: There is also now a module you can purchase to schedule.

Running custom process on a Schedule

Ditto to what Daryl said. This is how I typically accomplish this. I have the UD40 table set up as an “IT Use” table. I create a control record on that table, and then a BPM triggers when the control record gets updated. The Service Connect routine runs on a schedule, and the only thing that it does it a UD40.GetByID and a UD40.UpdateExt. The BPM has a condition Key1 = “RecordKeyValue” and CheckBox01 is changed from FALSE to TRUE. In the custom code of the BPM, the last thing I do is …