How do I list users by group?

I need to be able to produce a list of users within each group on our system. Anyway have any ideas on the SQL needed to produce this?

Find more posts tagged with

Comments

John W. Simon, Jr.

This isn't quite what you asked for but it is a start. The following SQL will produce a list of all the groups a particular userid is in:select b.name from kuafchildren a, kuaf b where a.id = b.id and a.childid = %1Put that in a Live Report with an input of User.

Liz_Connors_(sunvalleyfoodadmin_-_(deleted))

Take a look at KUAFCHILDREN and KUAF. The former holds the links between groups/projects and users and the latter holds the info on the users.Try something like :Select k.name,k1.name from kuaf k, kuaf k1,kuafchildren kc where k.id=kc.id and kc.childid=k1.id