Query builder

Use Query builder to reduce the list of records. The Query builder lets you build the SQL expression which you can also save to file and use in other projects.


Apply dynamic query

Applies dynamic query to the table. SQL engine can get varying statements whenever used.


Apply static query

Applies static query to the table. The statement of static query is always submitted in the same way.


Clear query

Erases the content of a query form


Reset table

Displays all records in the table (clears all queries applied to the table)


Load from file

Loads the expression from the file


Save to file

Saves the expression you have made to the file

Query builder can also be used in the same way for other layer types (points, lines, etc.)


Deleting entities selected by SQL builder

Selected records can be deleted by using an “Empty Layer...” function located in Map/Tools/Empty Layer... .
  1. Right click on any of records 
  2. Click Filter Data...

A Query builder pops up



  1. Type in the SQL expression or click on names and operator to build the expression interactively
  2. Click the Apply query button


Note: the Species attribute is a numeric lookup list 


  1. The list of records is reduced to those matching the query



  1. If you clear filter then Right click on any of records 
  2. Click Clear Filter



  1. Result