3 Replies Latest reply on Oct 11, 2016 9:53 AM by Doug Castell

Sql question: how to search contact without email within a group

dariobavicchi1 Oct 10, 2016 9:51 AM

I need to clean data from a contact group deleting from group the contacts without email address.

I tried to mix a couple of Sql examples at least to have a list of contcats without email address but, as i was sure, it does'nt work:

Select contact1.accountno, company, contact, city, zip

from contact1, contgrps as cg1, contgrps as cg2

where cg2.userid=cg1.recid and contact1.accountno=cg2.accountno and

cg1.userid='(public)' and

cg1.ref='GROUP-NAME'

and cg2.accountno not in (SELECT accountno from CONTSUPP where rectype = 'P' and contact = 'E-mail Address')

Can someone help me on that?

It would be perfect if i can also delete the contact from group because it seems not easy to do it inside Goldmine when you have to work with email address.

Thanks for help

1. Re: Sql question: how to search contact without email within a group

Doug Castell Oct 10, 2016 11:17 AM (in response to dariobavicchi1)

right click in the group member list, select to sort the members.

In the resulting window, select to sort them by company (or whatever field you prefer) and enter this in the 'reference text' box:
{&emailaddress}

Click OK.

Wait for the members to sort.

You'll now have an e-mail address (or not) in the reference column for each group member. You can click the reference column header to sort the list by the reference. This should put all the blank ones together. Click on the member at the top of the list who has a blank in the reference column and shift-click on the last member with a blank in the reference column. This should highlight all of those who have no e-mail address. You can then right-click on that highlighted mass of members and select 'Delete...' After confirming, you'll have removed them from the group.
Like Show 0 Likes(0)

Actions
2. Re: Sql question: how to search contact without email within a group

dariobavicchi1 Oct 11, 2016 3:22 AM (in response to dariobavicchi1)

Wow!
Thanks Doug this is really a great tip about Groups management.
It save us a lot of trouble and save me to deeply study SQL...

Thanks
Like Show 0 Likes(0)

Actions
3. Re: Sql question: how to search contact without email within a group

Doug Castell Oct 11, 2016 9:53 AM (in response to dariobavicchi1)

You're welcome!
Sure, I could probably write the SQL to do it, but when it can be done with the interface, why not?
Like Show 0 Likes(0)

Actions

Go to original post

Sql question: how to search contact without email within a group

1. Re: Sql question: how to search contact without email within a group

2. Re: Sql question: how to search contact without email within a group

3. Re: Sql question: how to search contact without email within a group

Actions

More Like This

Legend