Need to check user ID dynamically

[Sundaramoorthy]

We are having a requirement like need to validate the user based on his user id in report..but we are not having that user info table in current package..so,in order to achieve it, we are referring the customized SQL in report..

For validating the user id during report execution, we are supposed to have dynamic filters like CAMID for getting that user id..But as per the analysis, CAMID is returning only the user's mail address...

please suggest like is there any way to get that dynamic user id

[hespora]

Code Select Expand

#sq($account.personalInfo.userName)#

[Sundaramoorthy]

Thank you, Hespora..i also explored with the same & got the expected output.