Filtering

Filtering allows you to narrow down the objects shown in the selected or active layer from your workspace. Any column can be filtered and the columns can be added from the Columns button. The results of a filter can be saved to your account but it remains a static list and does not update as new data becomes available.

Each column in the attribute table has an input bar below its header. Depending on the column type, you may see text inputs, selectors, or date filters. For date filters, you can specify conditions such as on or after and on or before.

Two options to launch the filter dialog. Selecting the filter button in the columns pre-selects that field for filtering in the Filter dialog

Type in the input row the value and click enter to run a filter without opening the Filter dialog.

Without opening the filter dialog, users can type in the value right into the filter row and click enter to run a quick query. By opening up the filter dialog by clicking the Filters button, there are options to change the filter type and to add additional filters as either And or Or.

Filter Options

Depending on the data type, different filtering options are available:

Data Type	Filter	Example
Free Text (e.g. Company Name)	contains	Filter: Licensee contains Para returns Results: companies Paramount Resources Ltd. and Parallax Energy Operating Inc. and Valparaiso Energy Inc.
Free Text (e.g. Company Name)	does not contain	Filter: Field does not contain Willesden Green Results: Filters out all wells in Willesden Green field
Free Text (e.g. Company Name)	is not set	Filter: Pool is not set Results: Filters out all wells with a pool
Set List (e.g. Province or State)	is	Filter: Province is AB Results: Filters out wells from BC, SK, MB
Set List (e.g. Province or State)	is not	Filter: Province is not AB Results: Filters out all wells in AB
Number (e.g. Depth)	is greater than or equal to	Filter: TMD is great than or equal to 900m Results: Filters out all wells less than 900m
Number (e.g. Depth)	is less than or equal to	Filter: TMD is less than or equal to 900m Results: Filters out all wells above 900m
Number (e.g. Depth)	equals	Filter: TMD equals 900m Results: Filters out all wells where TMD does not equal 900.0m
Number (e.g. Depth)	is not set	Filter: TMD is not set Results: Filters out all wells with a TMD value
Date (e.g. Spud Date)	is on or after	Filter: Spud Date is on or after 01/01/2010 Results: Filters out all wells spud 01/01/2010 and earlier
Date (e.g. Spud Date)	is on or before	Filter: Spud Date is on or after 01/01/2010 Results: Filters out all wells spud 01/01/2010 and earlier
Date (e.g. Spud Date)	is	Filter: Spud Date is on 01/01/2010 Results: Only wells spud on January 1 are returned.
Date (e.g. Spud Date)	is not set	Filter: Spud Date is not set Results: Returns only list of wells without a spud date

Rendering and Saving Filter Results

After a filter has been input and clicked entered, it should create a temporary layer in your workspace and render on the map and in the attribute table. This layer can be saved by clicking the disc icon in the workspace associated with the temporary layer.

If a filter returns more than 10,000 objects, a popup will appear showing the total number of objects found with a Show button. Clicking Show loads all objects, but depending on the data size this may take some time.