How to make a BPM fire when a field is changed in a BAQ Report form

Kinetic ERP
1

I have a BAQ report that I run from a menu in Kinetic. The BAQ report form has an Option01 field which is a date field.

I would like a BPM to fire when this field is changed before previewing or printing the BAQ report so that I can populate the UD02.Key1 with the userid and UD02.Date01 with the Option01 date field via code in the BPM.

Is this possible?

I tried finding a callcontextbpmdata service in the method maintenance with no luck.

Please Help!!!

Thanks,
Richard

2

Technically, yes, but let’s get a little explanation of what’s going on first.

Yeah, there is no such thing. CallContextBPMData is a special dataview that is available with each BPM call, it is not a service. It is intended to be populated and used before a bpm call and is available inside the next bpm, and immediately after return. No guarantees after that.

The problem with the call context data for this particular application is that a report from a menu is most likely to be called from a SubmitToAgent (or a TransformAndSubmit) call, which schedules the report to be run by an outside agent, asynchronously, where the call context data will not be available. You can get away with using it with a RunDirect call, but that’s another story.

You might want to look into an alternative way to get what you want done, so please explain more, but in the meantime, I will explain what you can do.

Depending on the method called, (SubmitToAgent or TransformAndSubmit), you can add a pre-processing BPM on the appropriate one, and do something like this. (Off the cuff)

Pre-Processing on the appropriate one of these → Ice.Rpt.BAQReport.SubmitToAgent, Ice.Rpt.BAQReport.TransformAndSubmit

var report = ds.BAQReportParam.FirstOrDefault();

if(report.BAQRptID == "YourReport")
{
    
    var userID = Session.UserID;
    
    DateTime yourDate;

    bool success = DateTime.TryParse(report.Option01, out yourDate);
    
    if(success)
    {
        //Go write your stuff
    }
}

Now with all that being said, please explain more on what you are doing in case there is a better way to do it. It might be real important for matching because you will not have a task ID at this point.

2 Likes
3

That information should be available in the tables related to the report task, not really following why you would want to store this information again… I am with @klincecum with regards to asking for further explination…

3 Likes