Need to have list group members

[gihel]

I must have a special analys to my site
I need to get a list of all the members of a group.
Can you tell me how to do this in the BDD
SQL langage or php as you want
Thank you

[alfa24]

if you mean framework groups:

select * from core_user where idst in (select idstMember from core_group_members as gm inner join core_group as g on gm.idst=g.idst where groupid like "/YOURGROUPNAME")

for other type of groups (inside a course, org charts, etc.), ask.

[gihel]

That fine
thank you.
Have you the way to find group from an user. I have logUser, userId and I would like to know list of members the same group.

[alfa24]

This is a little more difficult, as in Forma "groups" are generical entities used for levels, custom groups in a course, core groups, org chart trees (each tree defining two groups, one for the root, one for its descendants), and so on. So I'm afraid you have to be more specific to get the right query.

[gihel]

OK thank you very much