Restrict the user to see the Groups

[muthukumaran.mohanarengan]

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@

[David Morton]

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.

[muthukumaran.mohanarengan]

Hi Dave,

 

Thanks for your Assistance. It works fine.

[muthukumaran.mohanarengan]

One more question:

Hi Dave,

 

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

[Suman Pramanik]

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

[muthukumaran.mohanarengan]

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.

[Suman Pramanik]

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