AnsweredAssumed Answered

Scoreboard Query To Find Active Contacts Not A Member Of Any Groups - 12.9

Question asked by Stuart_ on Sep 27, 2017
Latest reply on Sep 27, 2017 by Stuart_



Does anyone know the where clause to show all contacts that aren't a member of a group?


For example this works to show any inactive contacts that are still a member of a group: is not null AND delete_flag=1 AND type!=2308


But my logic of changing this to the following where clause didn't work. is null AND delete_flag=0 AND type!=2308


I've also tried creating a CABI report with a merged dimension on these objects without success, because the option to show null records doesn't seem to work.


Contact\Contact Extended\Contact - Group Member\Member uuid

Contact\Contact Detail\Uuid