How to get the Extension value of User Account for Currently Logged in user through Query

[former_member227405]

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

[former_member190023 · Accepted solution]

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