Report definition related question

General
1

1.How to find out list of cases id worked by a operator in a class.

  1. How to find out list of operator belongs to a access group.
2

@Vimal Vijayakumar

  1. Do you mean to say the operators who created the cases?

  2. Use OOTB report definition pzGetOperatorsForAccessGroup

3

@SohamM95

  1. No I want to know list of cases worked by operator.
4

Hi @Vimal Vijayakumar

  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)

List Cases created user.jpg
List Cases created user.jpg1314×754 122 KB

Or else you can use below sql query from Query Runner

select pyID, pxCreateOpName, pxCreateOperator from {CLASS:ABC-Work} where pxCreateOpName='devimpl'
  1. Just open the respective Access group and go to the operator tab, Then you find the list of operators for respective access group.

Operator.jpg
Operator.jpg1039×492 37.7 KB

Or else you can create an RD from Data-Admin-Operator-ID calss, and you can use the below coulms and filters.

List Of Operators.jpg
List Of Operators.jpg1189×724 108 KB

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