Justin Hill No Comments

I don’t usually like to get into SQL queries too much here, but this one is very useful. It will show you how to list (query) all contacts without history.

First, open the SQL Query window in GoldMine by selecting Tools | SQL Query from the top level menu. Then, copy and paste the following queries (one at a time) into the top window and then hit Query. The results will appear in the bottom pane and can be exported to Excel by right-clicking and selecting Output To | Excel.

Contacts With No History

SELECT ACCOUNTNO, COMPANY, CONTACT FROM CONTACT1 WHERE ACCOUNTNO NOT IN (SELECT ACCOUNTNO FROM CONTHIST)

Contacts with No History Since a Date (in this case, 1/1/2016, but feel free to change the date)

SELECT ACCOUNTNO, COMPANY, CONTACT FROM CONTACT1 WHERE ACCOUNTNO NOT IN (SELECT ACCOUNTNO FROM CONTHIST WHERE ONDATE > ’01/01/2016′)

Try these out, and have fun!

 

Leave a Reply

Your email address will not be published. Required fields are marked *