Selection Filter
Create/Edit Selection Filters
Use the Selection Filter option to create or, if applicable, edit selection filters that can be used to select subsets of drillhole database objects for loading or reporting purposes. Drillhole database objects are also called database keys, referring to all the data associated with a particular database key name.
Important Unlike earlier versions of Vulcan, which used.self files, selection filters are now saved in a .slf file. Because of these changes, versions of Vulcan after Version 8 will not recognise selection filters stored in a .self file that was created through an earlier version of Vulcan. The existing selection filters do not need to be recreated as the existing.self file can be converted to the new.slf file format through the Selection Filter. Once selected, the Selection Filter option will search the current working directory and automatically converts the older.self files to the new.slf format.
Instructions
On the Geology menu, point to Drilling, and then click Selection Filter to display the Selection Filters panel.
Use this panel to create a selection filters, as well as modify or delete existing ones.
[*]New Filter
To create a new selection filter, double-click on the [*]New Filter entry. Once selected, a new entry (named "untitled") displays. To rename the filter, double-click on the entry or right-click on the entry and select Rename from the displayed context menu.
To delete an existing filter, right-click on the entry and select Delete from the displayed context menu.
Database
Select the Choose button if you want to apply the selection filter to a specific database. Once selected, the Select Database panel displays.
The selection filter can be applied to a nominated Isis database or ODBC link. Selecting a database will result in table and field lists being provided through the Build Expression panel.
Select object where
Enter the expression (using the format <record>.<field> ). Select the Build button to construct the expression using Vulcan's SQL Expression Builder tool. Once selected, the Build Expression panel displays.
Click on the Table entry before selecting the necessary table and fields from the available lists. The database chosen through the Database field (of the Selection Filters panel) will populate the Sub-category and Item columns of the Build Expression panel.
|
Examples |
|---|
|
GEOL.LITH LIKE 'H*' |
|
ASSAY.AU > 5 AND ASSAY.AU < 10 |
|
ASSAY.AU> 5 OR ASSAY.AU < 10 |
|
ASSAY.AU = 5 |
|
ASSAY.AU <> 5 |
|
ASSAY.AU < HOLEID.DEPTH |
|
ASSAY.AU > HOLEID.DEPTH |
|
ASSAY.AU <= HOLEID.DEPTH |
|
ASSAY.AU >= HOLEID.DEPTH |
For example, ASSAY.TO will select drillhole database objects where one or more ASSAY records contain a TO field value that is less than the DEPTH field value in the HOLEID record. Brackets may be used to manipulate operator precedence (standard mathematical order of operation applies).
( ASSAY.TO.
Click OK.
