Re: How to Populate Logged user in Portlet (268 Views)
Reply
Occasional Advisor
Hp PPM
Posts: 9
Registered: ‎03-15-2011
Message 1 of 3 (296 Views)
Accepted 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
kwood55
Posts: 131
Registered: ‎04-09-2012
Message 2 of 3 (268 Views)

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:

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

Occasional Advisor
Hp PPM
Posts: 9
Registered: ‎03-15-2011
Message 3 of 3 (226 Views)

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.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.