- Tue Jul 10, 2018 5:42 am
#815092
I made a text box with the SQL code below thinking that it'll keep changing the current user with @@USER_LOGGED, but this seems to only work the first time but fails in subsequent tasks. How do I refresh USER_LOGGED in every task?
Code: Select all
select USR_USERNAME FROM USERS where USR_UID = (select USR_REPORTS_TO from USERS where USR_UID = @@USER_LOGGED)