Question
PEGA
Pegasystems Inc.
US
PEGA
Posted: Feb 21, 2025
Last activity: Apr 24, 2025
Last activity: 24 Apr 2025 3:50 EDT
Update parent case status based on earliest child case status
Our client has the following requirement that I’m wondering how best this can be achieved
- Parent (Submission) case creates multiple child (Transaction) cases
- Submission case status should reflect the earliest transaction case status
- Example: Transaction A == “Pending-Draft”, Transaction B == “Pending-Processing”, Transaction C == “Resolved-Completed” the Submission case status should be “Pending-Draft”
- As the transaction cases change status, the Parent should always reflect the earliest status
- Using the same example above, if Transaction B and C move to Resolved-Completed and Transaction A changes to “Pending-Processing”, the Submission case status should also reflect “Pending-Processing”
Any issues we should be on the look out for trying to apply this to the work status? Should we consider creating a separate property relationship and update strategy?
Heyy @DaveFinley,
To meet this requirement create a custom property on the parent case (e.g., EarliestChildStatus) to reflect the lowest/earliest status among all child cases. Use a Declare Trigger or a post-processing activity on child case status change to evaluate and update this property on the parent case. You’ll need to define a custom sort order for statuses (e.g., via a Decision Table or Map Value) since Pega doesn’t inherently know which status is "earlier." Avoid directly manipulating pyStatusWork if frequent updates may interfere with standard flow transitions or SLA behaviors.
Regards,
Mamatha Adiraju