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?