BPM widget to run a query and store the result for further use

[Mark_Wonsil]

Hey Michael,

This is from an Epicor Function but it’s identical to a BPM. It shows how to run the BAQ using widgets along with setting parameters. Once you have the result set, you can grab whatever fields you need from there.

Epicor Functions and BAQs

Sure. I added some logic to version the query, so I’ve left that off. But this is the basic: [image] 1.) Execute Invoke BO [image] [image] 2.) Fill in the Parameters using Fill Table by Query. (This is a single parameter BAQ in this case but you just have to make sure that you’ve filled out all mandatory parameters). [image] [image] 3.) Execute the query using the Invoke BO again [image] [image] 4.) Convert result to json and return using Custom Code. Remember to add your refere…