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))

This site uses cookies.

Some of the cookies we use are essential for parts of the site to operate and have already been set. We also use Google Analytics scripts, which all use cookies.
You may delete or block all cookies from this site in your browser options.