Downloads > PDF How To Guides > SQL Queries for GoldMine
-
GoldMine SQL Queries No.1- multicolumn, contacted in 365 days, new linked files
(48K)Three useful queries, just copy and paste into GoldMine’s at Tools\Filters and Groups\SQL Query:
1. A multi-column SQL Query for GoldMine showing logged calls per GoldMine User per month.
2. Contacts that have been contacted in the last 365 days.
3. All files linked into GoldMine in the past 7 days with their filenames and paths. -
GoldMine SQL Queries No.2- logged hours, yesterdays history and find emails.pdf
(51K)Three more useful queries, just copy and paste into GoldMine’s Query Editor at Tools\Filters and Groups\SQL Query Tab:
1. Report total logged history hours per customer per month.
2. List all the completed history items for yesterday with company and contact.
3. All GoldMine stored emails sent or received on a specific date with primary contact, company email address.
