Getting all groups which a user belong to

RT Developers
1

Hi,

does anybody know a nice method to get out in which groups a user is
added,
or do I have to query each group on its own for that?

Best regards
Timo

Timo A. Hummel, IT Specialist
IS Innovative Software AG Phone: +49 69 505030-302
Feuerbachstraße 26-32 Fax: +49 69 505030-505
60325 Frankfurt a.M. E-Mail:
mailto:timo.hummel@isg.de
GERMANY WWW: http://is.ag

2

Select Groups.Name FROM Groups, GroupMembers, Users WHERE
Groups.id=GroupMembers.GroupId AND GroupMembers.UserId=Users.id AND
Users.Name=‘username’;

I needed this on RT base, not on SQL base. I solved the problem by
querying each group, however, it’s not the nice solution.

Timo

Timo A. Hummel, IT Specialist
IS Innovative Software AG Phone: +49 69 505030-302
Feuerbachstraße 26-32 Fax: +49 69 505030-505
60325 Frankfurt a.M. E-Mail:
mailto:timo.hummel@isg.de
GERMANY WWW: http://is.ag

3

You should make a patch for RT to include this functionality, because I can
see it being pretty standard :wink:

Jay