Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Copper Super Contributor
Posts: 24
Registered: ‎12-30-2009

Group that lists Accounts without a Primary Contact?

I've about convinced myself this is a VBScripting project and not something that can be created using Groups. Can someone please confirm or illuminate? (SLX 7.2)

 

I want to create a Group that shows only Accounts which have NO primary Contact assigned.

Highlighted
New Member
Posts: 1
Registered: ‎04-20-2009

Re: Group that lists Accounts without a Primary Contact?

Hi,

 

this is something you can do in a group, but need some SQL knowledge.

I would write a SQL statement showing the accountid of accounts that have a primary contact, and make a group saying where accountid NOT in (select my accounts having primary contact).

 

The select statement is quite simple in this case :

select accountid from contact where isprimary = 'T'

 

Good luck.