Need to have list group members

Backend functionalities: user management, course management, reports, certificates, etc.
Post Reply
gihel
FormaLms User
Posts: 76
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

Need to have list group members

Post by 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
Senior Boarder
Posts: 933
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Need to have list group members

Post by 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.
I'm Jasmines, the One. If you need, you can contact me.

gihel
FormaLms User
Posts: 76
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

Re: Need to have list group members

Post by 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
Senior Boarder
Posts: 933
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Need to have list group members

Post by 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.
Last edited by alfa24 on Mon Mar 18, 2019 6:18 pm, edited 1 time in total.
I'm Jasmines, the One. If you need, you can contact me.

gihel
FormaLms User
Posts: 76
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

Re: Need to have list group members

Post by gihel »

OK thank you very much

Post Reply