The Elearning Community • Users not in a node.
Page 1 of 1

Users not in a node.

Posted: Fri Feb 22, 2019 12:48 pm
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

Re: Users not in a node.

Posted: Fri Feb 22, 2019 2:53 pm
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))