Question

To Financial
CA
Last activity: 17 Jan 2020 14:54 EST
Search case details based on active/completed assignment
We need to search case details based on active/completed assignment details like assigned id, assignment status, assignment urgency, assignment name etc. The active assignments exist in two tables – pc_assign_worklist, pc_assign_workbasket. And for completed assignments we need to search history table as is done OOTB. The problem is first we will have some 200 case ids fetched from elastic search and then we need to filter that 200 cases again based on assignment details. If we go by OOTB, we need to join 200 case ids with Assign-Worklist table, then another join with Assign-Workbasket table and then with History table. Next, we need to merge the results from all the joins to filter out the duplicates. The said approach is complex.
So,
Or
|
We need to search case details based on active/completed assignment details like assigned id, assignment status, assignment urgency, assignment name etc. The active assignments exist in two tables – pc_assign_worklist, pc_assign_workbasket. And for completed assignments we need to search history table as is done OOTB. The problem is first we will have some 200 case ids fetched from elastic search and then we need to filter that 200 cases again based on assignment details. If we go by OOTB, we need to join 200 case ids with Assign-Worklist table, then another join with Assign-Workbasket table and then with History table. Next, we need to merge the results from all the joins to filter out the duplicates. The said approach is complex.
So,
Or
|