How to get Current user's name in document UDF?

[Former Member]

Hi,

How to get Current user's name in document UDF?

I requried a query which will give me user's name who is currently loged in to the system.

My client want's to print the name of user who create the document, for that i have used Owner name field on document but we are able to chenge that field.

to avoid that i want the name of user who is currently loged in to system.

[KennedyT21 · Accepted solution]

Hi Swapnil Vichare ...

If you want to save the current user name in the UDF try the below query

SELECT T0.U_NAME FROM OUSR T0 WHERE T0.INTERNAL_K = $[USER]

But in all the documents the User sign is already captured by default you can also use the same for the printing too

Hope helpful

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

You can achieve through FMS.

1. Run below query and save it under query manager

SELECT T0.U_NAME FROM OUSR T0 WHERE T0.INTERNAL_K = $[USER]

2. Assign the above FMS in UDF field to update user name.

3. Add this UDF in your layout to display user name.

Hope helpful.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Try:

SELECT T0.U_NAME FROM OUSR T0 WHERE T0.INTERNAL_K = $[USER]

Thanks,

Gordon