Users not in a node.

Questions about the backend functionalities: configuration, user management, course management, ...
Post Reply
Graeme59
FormaLms User
Posts: 26
Joined: Thu May 05, 2016 6:53 am
Version: forma.lms 2.0
Location: UK
Contact:

Users not in a node.

Post by Graeme59 »

Hi,

Is there any way of isolating the users who are not added to any other node than the default Forma node?

Cheers

Graeme

alfa24
Senior Boarder
Posts: 586
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Users not in a node.

Post by alfa24 »

sql:
select * from core_user where idst not in (select idstMember from core_group_members where idst not in (select idst_oc from core_org_chart_tree))
I'm Jasmines, the One. If you need, you can contact me.

Post Reply