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

[Jay Kramer]

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

Jay

> > 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
>
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
>