Users not in a node.
-
- FormaLms User
- Posts: 124
- Joined: Thu May 05, 2016 6:53 am
- Version: forma.lms 2.0
- Location: UK
- Contact:
Users not in a node.
Hi,
Is there any way of isolating the users who are not added to any other node than the default Forma node?
Cheers
Graeme
Is there any way of isolating the users who are not added to any other node than the default Forma node?
Cheers
Graeme
Re: Users not in a node.
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))
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