list of users is part of XYZ group and they are not part of level 1 or 2 approver in cost center

raj149
Giga Guru

Hello Experts,

 

my requirement is 

 

I want to create a report by using below requirement

User  active=true and user has role "approver_user" or User is part of ABC group(sys_user_grmember) and

User is a member of  level 1 approver (referenced to user table) or level 2 approver (referenced to user table) in a cost centre table (cmn_cost_center)

 

please help me here to get users sys_ids by using script include.

If script is worked then i can call this script include in report

 

Best Regards,

Raj

0 REPLIES 0