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.
Go to Solution.
I can get the current logged in user and show his/her password expire date in v9.12:
SELECTusr.full_name FULL_NAME,usr.username USERNAME,usr.email_address EMAILADDRESS,usr.phone_number PHONENUMBER,usr.password_expiration_date PW_EXPIRATION_DATEFROMknta_users_v usrWHERE 1=1AND usr.user_id = [SYS.USER_ID]
I tried with sys.user_id in stead of username and it works :) Thanks for your help.