Wisconsin Department of Natural Resources

Help Home | Use the Advanced Query Builder

Use the Advanced Query Builder

The Advanced Query Builder tool make it possible for you build complex queries without knowing how to write SQL statements. First you select the layer you want to query, and then you select the records or fields that you wish to query as well as the operator and the value. You can also add multiple conditions to the query. When you run the query, the results display in the Results List like all other searches.

To build a query using the Advanced Query Builder:

  1. On the Maps & Data Sources tab of the toolbar, click Advanced Query.

    The Advanced Query Builder opens in the information pane.

  2. From the Query Layer drop-down list, select the layer that you want to query.

  3. From the Field drop-down list, select the field that you want to be in the first part of your query statement, for example, Owner Last Name.
  4. From the Operator drop-down list, select the operator, for example, Starts with.

  5. In the Value field, type in the value you want to query, for example "Smi".

    As you type, a list of possible options for this value displays.

  6. If you want to make the statement more specific, click Add new condition and define another set of parameters.
  7. To remove a condition, click the Remove Query Condition icon .
  8. Click Run.

    The results of the query display in the Results List.

Online Help © 2013 Latitude Geographics Group Ltd. All Rights Reserved.