Determine user

[1c3m4n]

Hi,

i get the currently logged in user by using the command

Code: [Select]

repository.GetCurrentLoginUser(false);
Is it possible to determine the forename and surname of this user?

Have a nice weekend.

Florian

[Geert Bellekens]

Florian,

I think the only way is to query the t_secuser table.
You can use Repository.SQLQuery to execute a query to the database.

Geert

[1c3m4n]

Hi Geert,

thank you for your answer. Can you please specify what i need to write in the SQL string parameter of the SQLQuery function.

Thanks.

Florian

[Geert Bellekens]

Something like

Code: [Select]

"Select u.FirstName, u.Surname from t_secuser u
where u.UserLogin = '" + loginVariable + "'" should do the trick.

Geert

[1c3m4n]

It works !

Thank you !

Florian