Users not in a node.

Backend functionalities: user management, course management, reports, certificates, etc.
Post Reply
Graeme59
FormaLms User
Posts: 117
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: 2009
Joined: Fri Nov 24, 2017 8:45 am

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))
Per supporto GRATUITO contattatemi in privato qui
Post Reply