Need to have list group members

Questions about the backend functionalities: configuration, user management, course management, ...
Post Reply
gihel
FormaLms Expert
Posts: 76
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

Need to have list group members

Post by gihel » Fri Feb 22, 2019 11:30 am

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
FormaLms Master
Posts: 435
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Need to have list group members

Post by alfa24 » Fri Feb 22, 2019 2:54 pm

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 Expert
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 » Sun Mar 10, 2019 5:57 pm

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
FormaLms Master
Posts: 435
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Need to have list group members

Post by alfa24 » Sun Mar 10, 2019 6:09 pm

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 Expert
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 » Mon Mar 18, 2019 5:59 pm

OK thank you very much

Post Reply