Check this:
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;
NJ