Filters, Groups & SQL Queries

Within GoldMine Filters, Groups, and SQL Queries are our ways of segmenting the database to pull specific records for emailing, calling, or simply viewing in list form.

Here is a 'cheat sheet' on which to use to get the desired data.

For 'On What': This is relatively self-explanitory.  Each has different criteria on which you can select data and criteria from.

For 'Statis vs. Dynamic': This refers to how 'fresh' the data is.  For Filters & SQL Queries whenever they are executed they return the database as how it exists currently.  For Groups, they exist as they are built at the point in time they are built, they are a snapshot of the datbase at a specific point in time.

For 'Speed': Groups are the fastest.  If you are using GoldMine Standard Edition Filters & SQL Queries can be slow to access because they have to scan the entire database when they are run.  Groups will be faster because they are prebuilt.  If you are using GoldMine Corporate Edition they will almost always be incredibly fast becauase Microsoft SQL Sever is very efficient at performing these operations.

For 'Difficulty': Filters are the easiest as they provide the last number of options.  As one might expect, as your options increase so does the difficulty.