Question
Cognizant Technology Solutions
GB
Last activity: 8 Feb 2017 4:37 EST
Poor performance due to multiple time DB hits (pc_assign_worklist & pc_assign_workbasket).
I have a requirement where I need to show list of cases for a particular user/caseowner. Now each case can have multiple assignments, where all the assignment owners should be same as the case owner. For this I am taking up each case and searching pc_assign_worklist & pc_assign_workbasket for assignments; then I am comparing all the pxAssignedOperatorID with caseowner. But if have 1000 cases in the list, I am hitting the two DBs 1000*2=2000 times. This is causing the final list to be populated after 10-15 minutes.
How to resolve this issue? Thanks in advance.
Areteans Technology Solutions
AU
Hi,
By saying case owner, did you mean to say the person who created the case? In that case, a workbasket cannot be the creator of a case. So that takes on table out of the equation. Then you can do a join of the work table and the assign-worklist table to get a list of cases that are having the same creator name (Inner join where work created operator == assignment created operator) This will give you a list of records that are pending with the user who created the case.
Hope this helps.
Regards,
Ratan Balaji.
Pegasystems Inc.
IN
Hi,
I am actually confused on the exact requirement here. Do you want to show all the cases where X is case owner ?
Could you clarify your requirements a bit more so that we can provide a suggestion for the same.
Cognizant Technology Solutions
GB
yes..the requirement is to show cases for a user/pid for e.g. let P101234 be a pid.
It will show all the cases whose case owner is P101234 on a condition.
The condition is as follows-
suppose case1,case2,case3 are 3 cases whose caseowners are P101234.
Now suppose case1 has 2 assignments- c1ass1, c1ass2. pxAssignedOperatorID for c1ass1 is WB123,
pxAssignedOperatorID for c1ass2 is P101234.
Now suppose case2 has three assignments - c2ass1, c2ass2, c2ass3. pxAssignedOperatorID for all the three assignments is P101234.
Now suppose case3 has 1 assignment - c3ass1. pxAssignedOperatorID for c3ass1 is K123456.
so in the final list only case 2 should appear as in other cases, there is atleast 1 assignment which does not belong with P101234.