How To Find Everyone You Spoke About “X” With…

If you are diligent about recording what you spoke with your contacts about in GoldMine…

It’s very easy to find everyone you spoke about a topic with.

Let’s say I want to find everyone where I mention ‘gadgets’.

Here’s the SQL Query:

select contact1.contact, contact1.company, conthist.ondate,
conthist.ref from contact1, conthist where contact1.accountno =
conthist.accountno and conthist.userid = 'BILL' and conthist.notes like
'%Gadgets%' order by ondate

Simply change the ‘BILL’ to your userid and replace ‘Gadgets’ with your search term!

To use this, from GoldMine’s main menu choose Lookup | SQL Queries then Copy & Paste the above in the top section then click Query.  If you are using GoldMine Premium Edition then Tools | Filters & Groups and then the SQL Query tab.