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_

Hello,

 

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:

 

group_list.id is not null AND delete_flag=1 AND type!=2308

 

But my logic of changing this to the following where clause didn't work.

 

group_list.id 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

 

Thanks

Stuart

Outcomes