Adhoc Query / Advanced Search

Description of the tool

An Adhoc Query or an Advanced Search gives you the ability to search on fields in a custom manner. It provides more flexibility than the Search Panel but also requires detailed knowledge of the data and search methods so it may not be suited to all Weave users. 

As with standard searches from the Search Panel, the search works on the Active Layer (the selectable layer). The features that meet your specified criteria will be highlighted on the Map Window.

The query options of the Adhoc Query menu will be configured by your Weave System Administrator. 

How to use the tool

Prerequisite:

None

Steps:

1. Set the Active Layer to the layer you would like to search.
    
2. Click on the Adhoc Query button.
   
    
3. Define the search parameters (using SQL) in the Advanced Search menu. 
    
4. Once you have constructed your search statement, use one of the buttons long the bottom of the panel. The buttons perform these functions:
   • New - This will create a new selection, and will replace any previous selections you had for the Active Layer.
   • Add - This will add the selected features to the existing selection set.
   • Remove - The features that result from the Search operation will be removed from the selection set for the Active Layer. 
   • Refine - All bar the selected features will be removed from the selection set. 
   • Cancel - Closes the Advanced Search menu without running any searches. 
      

After running an Advanced Search operation, the selected features are highlighted in the map in bright blue and the records appear in the Data Grid.

A sample Advanced Search is shown below, but these will vary markedly from one organisation to the next.