Clarity PPM

Expand all | Collapse all

Restrict the user to see the Groups

Jump to Best Answer
  • 1.  Restrict the user to see the Groups

    Posted 01-22-2018 08:02 AM

    Hi ,

     

    I created a Grid Portlet. If I filter my Id shows what the are the Groups i have assigned  and if I filter other userid it shows.

     

    I want to restrict for other users. If the user login the clarity  that particular user can view his/her own Group, not for others.

     

    Here is my code , how can I restrict for other users.

     

    SELECT
       @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:ug.group_id:group_id@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:usr.USER_NAME:USER_NAME@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:usr.FIRST_NAME:FIRST_NAME@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:usr.LAST_NAME:LAST_NAME@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:grp.group_name:group_name@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:grp.description:description@
       from 
    cmn_sec_user_groups UG,
    cmn_sec_groups_v grp,
    CMN_SEC_USERS usr
    WHERE
    ug.group_id = grp.ID
    and ug.user_id           =usr.id
    and grp.language_code = 'en'
    AND usr.user_Status_id=200
    and @filter@



  • 2.  Re: Restrict the user to see the Groups
    Best Answer

    Posted 01-22-2018 08:23 AM

    The NSQL built-in;

     

    @WHERE:PARAM:USER_ID@

     

    will return the user_id of the logged in user, so you can use that in some logic in your WHERE clause to do what you need.



  • 3.  Re: Restrict the user to see the Groups

    Posted 01-22-2018 08:41 AM

    Hi Dave,

     

    Thanks for your Assistance. It works fine.



  • 4.  Re: Restrict the user to see the Groups

    Posted 01-22-2018 08:42 AM

    One more question:

    Hi Dave,

     

    Is it possible to Schedule a job to stop the jaspersoft and start the Jaspersoft in clarity.



  • 5.  Re: Restrict the user to see the Groups

    Posted 01-22-2018 08:53 AM

    Jaspersoft is not managed by PPM and its needs to be managed separately 



  • 6.  Re: Restrict the user to see the Groups

    Posted 01-22-2018 09:06 AM

    Hi Suman,

     

    Thanks...So its not possible to stop and start the Jaspersoft via clarity scheduled Jobs. Is it?

     

    One question:

     

    Is it possible to schedule below service Niku stop all via clarity job.



  • 7.  Re: Restrict the user to see the Groups

    Posted 01-22-2018 09:07 AM

    Answer to both is no. You need to manage Jaspersoft via Jaspersoft app and not via PPM