[rt-devel] Getting all groups which a user belong to

[Timo Hummel]

> 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 at isg.de
GERMANY                                 WWW:    http://is.ag