cancel
Showing results for 
Search instead for 
Did you mean: 

Printing current username on layout

a_grootens
Active Participant
0 Kudos

Hi all,

I would like to print the username of the current logged in user (the user who actually prints the document) on a layout (picklist, delivery) using the PLD

Is there a system variable available or anyone has done this before?

Kind regards

Andy

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can create an UDF, heres the query to get log user Fullame,

Select UPPER(T0.Lastname) + ', ' + UPPER(T0.Firstname)  as OWNER from dbo.ohem T0 WHERE T0.Userid = $[USER]

Regards,

Clint

Former Member
0 Kudos

I think you can just add the OUSR table & select the user name

a_grootens
Active Participant
0 Kudos

Hello Julie,

Thanks for your reply, but the OUSR.U_name field represents the creator of the document and not the current user. That's my problem. I think I will have to create a UDF with Select $[USER]. But how to trigger this with a Formatted Search?

Kind regards,

Andy

Former Member
0 Kudos

Hello Andy,

You may assign this FMS to UDF by auto refresh against Remarks fields. Just need user to click on that field since nothing might be changed when user printing.

Thanks,

Gordon

Former Member
0 Kudos

Did you test this? We have it working to display the logged on user for a customer site. Make sure you don't link it or realte it to anything.