Skip to main content
CRMGoldMine CRM

GoldMine: Edit / Clone GoldMine Filters

By February 27, 2019No Comments

When you need a filter that is similar to one you already have there is no need to create a new one.  You can clone it, change it, and save as a new filter.

Cloning a Filter

  1. Select Tools | Filters
  2. Select the filter to be cloned and click on the Preview tab.
  3. Click the Save button.
    1. In the “Save Query” window, select “Save expression as a new filter.”
    2. Deselect the “Activate Query once it is saved” checkbox
    3. Click OK.

The “New Filter” window will appear to modify the “Filter Name:” field.  You can also change the “Owner:” of the cloned filter and have it stored under a different username.

Editing a Filter

GoldMine uses two types of expressions for its filters and, when editing, both types need to be considered.  There is the dBASE expression and the SQL expression.  Logically speaking, both expressions need to indicate the same thing in order for the filter to work properly.

  1. At the bottom of the New Filter window are the radio buttons that allow you to edit each type separately.
  2. First, select the dBASE Expr. radio button and then click Edit Expression.  Modify the code as necessary.
  3. When the dBASE expression has been edited, click OK.
  4. Next, select the SQL Query radio button and click Edit Expression again.  Make the equivalent changes and click OK twice to finish saving it as a new filter.

The Filters and Groups window will be focused back on the Filter tab with the new filter selected.  Click on the Preview tab and then the Search All button to test it out.

Becci MG

Author Becci MG

More posts by Becci MG

Leave a Reply

Skip to content