Wednesday, June 3, 2015

GoldMine : How Many Records are There?

This is surprisingly difficult, isn't it? I mean, all we want to know is how many records we have in GoldMine! Where is this number?

...there are ways to see "summaries" in GoldMine. For example, you can right-click within the Search Center and check "Summary". This provides a count in the bottom left hand corner of the Search Center. But it only counts records in the current search.

...if we want to know ALL the records in our GoldMine, we must use SQL queries;

1. Select Tools | SQL Query from the top level menu.

2. In the query box, use the following queries to generate record counts;

This one gives you the count of all Contact Records;
SELECT COUNT(*) FROM CONTACT1

This one gives you the count of all History Records;
SELECT COUNT(*) FROM CONTHIST

3. Simply copy and paste these queries (one at a time) into the box and hit "Query".

4. You can always save a query for re-use by using the "Save" button in the upper right hand corner.

Try it and have some fun!

2 comments:

Chanel Replica Handbags said...

As for the person who would use the bag, for some reason I was seeing the kind of girl that I often recognise in Los Angeles. These girls generally never venture out in the streets, but when they do, they wander round – with their perfect skin – at these vast organic markets

PLC training in chennai said...


WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai