[PipSqueak]

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)

[amosbatto]

Create the following trigger:

Code: Select all

$managerId = userInfo(@@USER_LOGGED)['reportsto'];
@@reportsToUsername = $managerId == '' ? '' : userInfo($managerId)['username'];

Then create a text field in your Dynaform associated with the "reportsToUsername" variable.
Set the the above trigger to execute before the DynaForm.

[PipSqueak]

Thanks Amos,

How do I get the 2nd level reporting to e.g. manager's manager.

Regards

[PipSqueak]

Never mind, I got it

Code: Select all

$managerId = userInfo(@@USER_LOGGED)['reportsto'];
@@reportsToUsername = $managerId == '' ? '' : userInfo($managerId)['username'];

$managerId2 = userInfo($managerId)['reportsto'];
@@reportsToUsername2 = $managerId2 == '' ? '' : userInfo($managerId2)['username'];