Question
Cognizant
IN
Last activity: 4 Apr 2024 9:21 EDT
Report definition related question
1.How to find out list of cases id worked by a operator in a class.
2. How to find out list of operator belongs to a access group.
Accepted Solution
Updated: 4 Apr 2024 9:21 EDT
Tata Consultancy Services
IN
1. If you want to get list cases created by a particular user, add the below columns and user filter conditions as mentioned below. (Respective Work Class)
Or else you can use below sql query from Query Runner
select pyID, pxCreateOpName, pxCreateOperator from {CLASS:ABC-Work} where pxCreateOpName='devimpl'
2. Just open the respective Access group and go to the operator tab, Then you find the list of operators for respective access group.
Or else you can create an RD from Data-Admin-Operator-ID calss, and you can use the below coulms and filters.
Or you can use query from the Query Runner
1. If you want to get list cases created by a particular user, add the below columns and user filter conditions as mentioned below. (Respective Work Class)
Or else you can use below sql query from Query Runner
select pyID, pxCreateOpName, pxCreateOperator from {CLASS:ABC-Work} where pxCreateOpName='devimpl'
2. Just open the respective Access group and go to the operator tab, Then you find the list of operators for respective access group.
Or else you can create an RD from Data-Admin-Operator-ID calss, and you can use the below coulms and filters.
Or you can use query from the Query Runner
select pyUserIdentifier, pyUserName, pyAccessGroup from {CLASS:Data-Admin-Operator-ID} where pyAccessGroup='Insurance:Administrators'
I hope this will help you.
Thanks,
Ashok
Maantic Inc
IN
1. Do you mean to say the operators who created the cases?
2. Use OOTB report definition pzGetOperatorsForAccessGroup
Accepted Solution
Updated: 4 Apr 2024 9:21 EDT
Tata Consultancy Services
IN
1. If you want to get list cases created by a particular user, add the below columns and user filter conditions as mentioned below. (Respective Work Class)
Or else you can use below sql query from Query Runner
select pyID, pxCreateOpName, pxCreateOperator from {CLASS:ABC-Work} where pxCreateOpName='devimpl'
2. Just open the respective Access group and go to the operator tab, Then you find the list of operators for respective access group.
Or else you can create an RD from Data-Admin-Operator-ID calss, and you can use the below coulms and filters.
Or you can use query from the Query Runner
1. If you want to get list cases created by a particular user, add the below columns and user filter conditions as mentioned below. (Respective Work Class)
Or else you can use below sql query from Query Runner
select pyID, pxCreateOpName, pxCreateOperator from {CLASS:ABC-Work} where pxCreateOpName='devimpl'
2. Just open the respective Access group and go to the operator tab, Then you find the list of operators for respective access group.
Or else you can create an RD from Data-Admin-Operator-ID calss, and you can use the below coulms and filters.
Or you can use query from the Query Runner
select pyUserIdentifier, pyUserName, pyAccessGroup from {CLASS:Data-Admin-Operator-ID} where pyAccessGroup='Insurance:Administrators'
I hope this will help you.
Thanks,
Ashok