Building a Query

The Query Builder tab allows tabular queries on the attribute data from any of the currently displayed layers.

To build a query, follow the steps given below:

Select the Query Builder tab.
From the Query In drop-down list, select the geographic area to be queried. You can choose to see all the data, data within the current map view or choose one of the annotations you have drawn to search for data that is inside or touches it.
From the From drop-down list, select the name of the map layer you wish to search.
From the Sort By drop-down list select which column of data to sort the results by. You can also re-sort the data once the results are shown.
Select Custom Filter from Filter drop-down list to customize search. The Filter Criteria section is displayed.
From the Where drop-down list select the column that is to be queried.

Note: If there are less than 50 records associated with selected column then criteria is shown as drop down list with multiselect option and if records are more than 50 then criteria is shown as text box.

Select the search operator from the drop-down list. It provides following search operators.

Operator	Name	Description
=	equal to	This function only retrieves records that exactly match the text or value entered in the criteria text box.
<>	not equal to	This function looks for all values that are different from the value entered in the criteria text box.
<	less than	This function looks for all values lower than the value entered in the criteria text box.
>	greater than	This function look for all values higher than the value entered in the criteria text box.
>=	greater than or equal to	This function looks for all values higher than or at the same level as the value entered in the criteria text box.
<=	less than or equal to	This function looks for all values lower than or at the same level as the value entered in the criteria text box.
Like	Like	It looks for records in the chosen field that contain the criteria entered in any way.

Note: Multiselect pick list is supported for {equal, not-equal and like} operators. For others, simple pick list is displayed.

Enter a value in the Criteria text box and click Go.
Click sign to add AND conditions to the query filter. If you want to delete a query condition click the button to delete the current row.

Note: You can add up-to 5 search criteria.