Clarity

 View Only
  • 1.  Object role Assignees at PM approval process

    Posted Oct 19, 2016 08:34 AM

    Hi All, 

     

    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:

     

     

    Matej



  • 2.  Re: Object role Assignees at PM approval process

    Posted Oct 19, 2016 10:24 AM

    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



  • 3.  Re: Object role Assignees at PM approval process

    Posted Oct 20, 2016 01:48 AM

    Hi Navzjoshi, 

     

    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.

     

    Matej



  • 4.  Re: Object role Assignees at PM approval process

    Posted Oct 25, 2016 08:54 PM

    Hi navzjoshi00 - Any other ideas for this one? Thanks! Chris