Question
Infosys Limited
IN
Last activity: 6 Sep 2022 5:41 EDT
Display assignments from work basket based on skills
Lets say an operator has the access to the workbaskets A,B,C. If operator clicks on workbasket A, then only the assignments which matches the operator skills should be displayed. The same applies for the B and C workbaskets as well..
How to achieve this?
Capgemini
GB
When running GetNextWork, Pega runs the activity getContentForGetNextWork to get the list of assignments filtered by operator skills. The SQL query that it generates is below (uses the indexes on operator skills and the assignment skills).
You could either try replicating the SQL in a report definition, or call the SQL manually either running the activity as-is, or defining a Connect SQL rule to build your list.
This takes parameters pxassignedoperatorid = workbasket name, and pyuserIdentifier = current operator to check skills
When running GetNextWork, Pega runs the activity getContentForGetNextWork to get the list of assignments filtered by operator skills. The SQL query that it generates is below (uses the indexes on operator skills and the assignment skills).
You could either try replicating the SQL in a report definition, or call the SQL manually either running the activity as-is, or defining a Connect SQL rule to build your list.
This takes parameters pxassignedoperatorid = workbasket name, and pyuserIdentifier = current operator to check skills
SELECT wb0."pxobjclass" AS "pxObjClass",
wb0."pxurgencyassign" AS "pxUrgencyAssign",
wb0."pxassignedoperatorid" AS "pxAssignedOperatorID",
wb0."pxrefobjectclass" AS "pxRefObjectClass",
wb0."pxflowinskey" AS "pxFlowInsKey",
wb0."pzinskey" AS "pxInsHandle"
FROM pegadata.pc_assign_workbasket wb0
WHERE wb0."pxobjclass" = ?
AND ((( wb0."pxassignedoperatorid" = ? )))
AND wb0.pxrequiredskillscount <= 0
AND wb0.pxrequiredskillscount = (SELECT
Count(a_skills.pxskillname) match_skill
FROM
pegadata.pr_index_assignmentskills a_skills
JOIN
pegadata.pr_index_operatorskills o_skills
ON
a_skills.pxskillname = o_skills.pxskillname
AND a_skills.pxskillrating <= o_skills.pxskillrating
WHERE o_skills.pyuseridentifier = ?
AND
a_skills.pxinsindexedkey = wb0.pzinskey)
AND wb0.pyerrorassignment IS NULL
ORDER BY wb0."pxurgencyassign" DESC