on 2016 Feb 03 11:25 AM
Hi ,
I want to use extension value(Value List) persent under each User account for currently logged-in user to get a Report(differentiate within each user designation)
I am not able to find the exact query which can fetch extension value of Currently logged in user.
Please kindly provide some helpful feedbcak.
Thanks
Peeyush Ranjan
Request clarification before answering.
Hi Peeyush,
You can make use of the built in token <%CURRENT_USER_ID%> to fetch the current user object id. You can use it to restrict FCI_UPP_USER_ACCOUNT using clause:
WHERE OBJECTID = <%CURRENT_USER_ID%>
To get the value of the extension (provided it's defined at header-level) you can join with <%EXT_TABLE(upp.user_account)%>
Regards,
Bogdan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.