User Group Account Request

[EA2412]

Hi all

is there any possibility to read back the assigned user group for the currently logged on user via c#?

Thanks in advance

[Geert Bellekens]

I don't see an operation to get it directly, but you can use Repository.SQLQuery to get the name of the group.

Geert

[EA2412]

Hi Geert

thanks for your reply. Is it possible that you can provide any code fragment to me?

Thanks in advance

[Geert Bellekens]

Use following query in the Repository.SQLQuery.
That will return an xml formatted string with the resultset of that query.

Code: [Select]

select groupname from ((t_secgroup g
join t_secusergroup ug on ug.GroupID = g.GroupID)
join t_secuser u on ug.UserID = u.UserID)
where u.UserLogin = 'Geert'
Geert