Next Assignment functionality does not retrieve the right cases
The Get Next Work functionality does not retrieve cases with least time due within the same urgency. The functionality retrieves cases randomly from the same urgency level.
Steps to Reproduce
1. Create cases with the same urgency but with deadline time differing by minutes
2. Click the Next Assignment button
This behavior is as per Pega product design.
Here’s the explanation for the reported behavior:
The Get Next Work functionality’s SQL orders the urgency in descending order (that is, ORDER BY wb0.pxUrgencyAssign DESC). The out-of-the-box logic to retrieve the case with least time due when the urgency is the same for multiple items is not included in the functionality.