Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

How to Populate Logged user in Portlet

Go to Solution

How to Populate Logged user in Portlet

I have created  portlet to calculate total time logged against PTO (paid tike off) task for each user. In this porlet filetr is set as 'Logged User' to calculate PTO for him


I want to share this portlet on every users dashboard However I want to populate current logged in user for that portlet so that user dont have to enter his name specificaaly in portlet fielter. 


Something similar to my time sheets Or My request which populates request for logged in user.


I tried [sys.username] however PPM does not allow to use this token in SQL or Portlet.


Please help.



Trusted Contributor

Re: How to Populate Logged user in Portlet

I can get the current logged in user and show his/her password expire date in v9.12:

usr.full_name FULL_NAME,
usr.username USERNAME,
usr.email_address EMAILADDRESS,
usr.phone_number PHONENUMBER,
usr.password_expiration_date PW_EXPIRATION_DATE
knta_users_v usr
AND usr.user_id = [SYS.USER_ID]


Re: How to Populate Logged user in Portlet

[ Edited ]

I tried with sys.user_id in stead of username and it works :) Thanks for your help.