Filter Conditions (SQL Builder)

Use this dialog to define conditions that filter out unwanted rows when importing fields (columns) from an external database into a Geosoft database. You may only want specific rows to be imported.

Filter Conditions dialog options

Field

Select one or more fields to apply filter conditions to.

Condition

Choose a condition type for the selected field(s):

  • equals
  • does not equal
  • less than
  • greater than
  • less than or equal to
  • greater than or equal to
  • between

Value

Enter the value(s) to compare against the selected field(s).

Application Notes

If this dialog is opened from the general Database menu, you'll see two additional options:

  • Select the database you want to import

  • Choose the fields to import

If the dialog is opened via the Drillhole ODBC Import menu, those options won’t appear—they’ve already been specified by the Drillhole tool that launched the dialog.

Condition Syntax

  • Use wildcards (%) with string fields. For example, to select only Collar IDs that start with "AX", specify: "equals AX%".

  • For the between condition, separate the two numbers with a comma. Example: "between 10,19."

  • Apply OR logic when using multiple conditions on the same field.

    Apply AND logic when filtering across different fields.

See Also: