How to search



In the Search Bar, enter what you are looking for and click the green Search button. See search query syntax for more information.


Search query syntax

Whereoil is a search centric system and search query syntax is important.


To make your search results more precise and relevant, use quotes around any terms containing spaces within your search query.

i.e. “correlation maps” instead of correlation maps.

Failure to use quotes would result in a search for correlation OR maps and this would not provide the expected results.

Operators and Query construction

All boolean operators: OR, AND, NOT must be UPPERCASE to be recognised as operators.

A search query can not start with a logical operator.
i.e. NOT perforated
would be invalid.


To search for several items, simply separate each item with a space and the search result will contain any of the items.
i.e. “7/11-7″ “7/11-7 R” “7/11-10 S”

is the same as searching for
“7/11-7″ OR “7/11-7 R” OR “7/11-10 S”


AND is a very powerful operator. It signifies that all terms in the search query should be found within the same result.
i.e. to find cores for well 25/5-1, enter
25/5-1 AND core

do not use
25/5-1 core or “25/-1 core”


The NOT operator enables the exclusion of  unwanted results from your query.
i.e. searching for “Ekofisk” will provide results for both “Ekofisk” and “Vest Ekofisk”. To exclude “Vest Ekofisk” just search for:
ekofisk NOT vest


The ? or * wildcards can be used to replace single or multiple characters within the search query. However, wildcards cannot be used at the beginning of a query.
i.e. to find all records containing troll, enter troll* as a search query.

Grouping ()

If you want to find all wells from UK and Norway that hit the top of Jurassic period, you need to search for both “late jurassic” and “upper jurassic” due to time period naming differences between the UK and Norway.  You can group the search terms using Brackets ()
i.e. (upper late) AND jurassic

Advanced search examples

To search for water producing wells:
producing AND water NOT injector

To search for public surveys and licenses expiring in March 2008 in Norway:
[20080301 TO 20080331]

Such search results can be displayed on the map if applicable, by clicking on the send all results to map icon.



Searching within recently updated records



To search within recently updated records select Last DayLast Week or Last Month instead of All on the Search Bar.

Restricting search to specific data types

Searches can be limited to specific data types using Favourites. Data types are set as Favourites by clicking on the Set as Favourite icon located next to individual Data Types. Searches are then restricted to within Favourites by clicking on Restrict Search To Favourites icon located to the right of the Search Bar. Favourites are retained between user sessions. For example, searching for all Troll fixed facilities is achieved by -Setting the facilities data type to be a Favourite by clicking on the Set As Favourite icon located next to the Facilities Data Type.







Setting the search to be restricted to favourite data types by clicking on Restrict Search To Favourites icon located to the right of the Search Bar.



Entering Troll in the Search Bar and clicking Search.