Assignees. Do som" />
I'd like to know how can I find which users is behind the group called "Project managers" at
PM Approval process, under Action Item -> Assignees. Do someone knows this info? I couldn't able to find it....Really appreciate your help, thx.
Screen is from Clarity 14.3 Sandbox version:
Learn PPM with Rego: Jaspersoft Timeout Settings, Custom Fields in the AI, New Create & Update Process, Query a Group, a…
Learn PPM with Rego: Jaspersoft Timeout Settings, Custom Fields in the AI, New Create & Update Process, Query a Group, and Estimate from Allocations
The query below pulls users and their user status, as long as they're assigned to a security group defined by a parameter in the query.
Feel free to modify this based on your needs, and let us know if you need additional information.
SELECT res.full_name, cap.name, u.user_status_id
FROM cmn_sec_user_groups grp, srm_resources res, cmn_sec_users u,
(SELECT id, group_code FROM cmn_sec_groups
WHERE is_active = 1
AND group_role_type = 'GROUP') group_list,
(SELECT * FROM cmn_captions_nls
WHERE table_name = 'CMN_SEC_GROUPS'
AND language_code = 'en') cap
WHERE group_list.id = grp.group_id
AND res.user_id = grp.user_id
AND cap.pk_id = group_list.id
and res.user_id = u.id;
Thanks for reply but your query shows security groups which I know and could be also checked through Clarity GUI Admin -> Groups. But this is slightly different. As shown in my screenshot, it's called 'Object roles' with name "Project managers". Is object roles the same as security groups? I don't think so because seeing again on my screenshot, the third tab is "Groups" which are our security groups. So Object roles should be something different....
Thanks for your help.
Hi navzjoshi00 - Any other ideas for this one? Thanks! Chris