Question
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
***Edited by Moderator Marissa to update SR Details*** |