I have two custom Business Processes. BP-1 is a single instance process. BP2 can have multiple records.
Total Amount from all BP2 records should reflect in BP1.
I feel this can be achieved by using a SYS Numeric Query Based data definition and then setting the triggering elements.
Where do I input the query for calculating the amt field?
Thanks in advance.
Assuming you have added the query-based DE (QBDE) to the BP in uDesigner, you do this in Unifier, under Company Workspace tab. Switch to Admin mode, then navigate to Configuration > Business Process. Highlight the BP that is going to hold the amount and click Open > Data Elements. You should see a Query tab. In the upper form, select the QBDE element and define any conditions, such as all records must be in approved status and they total on the Amount field.
Nice piece of functionality!