Question
Bits in Glass
CA
Last activity: 3 Feb 2020 3:33 EST
How to compare a Pagelist and a value list in report definition, is it feasible?
Scenario:
I have list of assignments and every assignment is having a different skill set to it. I need to find Operators who have the required skill present and can perform all the selected assignments.
example:
Assignment1- skill(APAC)
Assignment2- skill(EMEA)
Assignment3- skill(LATAM)
need to configure a report which should get the operators who have all three skills listed in their profile.
do I need to configure an Activity to achieve this or this can be handled by Report definition.
Accepted Solution
Bits in Glass
CA
we have used an Activity with a step containing RDB-List method. In RDB-List, we have used group by clause with having clause.
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
I think this use case cannot be achieved by using the report definition. We can try it using activity.
Pegasystems Inc.
US
I think it depends on how you want to view the results, but you may be able to do this with a report definition using a join on the skill set.
Accepted Solution
Bits in Glass
CA
we have used an Activity with a step containing RDB-List method. In RDB-List, we have used group by clause with having clause.