Question
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
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
1. Do you mean to say the operators who created the cases?
2. Use OOTB report definition pzGetOperatorsForAccessGroup
Accepted Solution
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