Tip:

In addition to simple filtering of your dataset, you can have simple statistics of numeric attributes calculated. To perform this, simply select attribute in selection table and click SUM (total)or AVG (average)button. Subsequently, desired statistics appear with query result.

For average it is also possible to select whether the attribute will be weighted by another attribute (integer type). For more details, see the chapter Simple statistics (detailed)




Moreover you can order the records of query result using specific column(s) (ORD) and choose between ascending and descending order.

Attributes type lookup list and integer can be also group by the same values (GRP).

In grouped query task each attribute must be marked either as SUM/AVG or GRP.


Repeating consecutive values can be skipped when exporting to Excel (SKIP). However, if the value is to be displayed when changing the value in another attribute, it is possible to activate this control attribute or even combine more control attributes


Active plot / all plots

When Limit selection to current item of 'Plot' is selected, only records from active plot will be filtered. On the other hand, if No predefined limits for selection is active, all records in database become point of interest for the tool.


Using dynamic queries

Dynamic query can be accessed by typing of ? symbol (open parameter) instead of definitive value into the respective field in conditions definition. See chapter Dynamic SQL Queries for additional information.
  1. Create new task
  2. Make sure, that the edit mode is active



  1. Switch to Selection tab
  2. Tag those attributes, which will be available in subsequent query definition and will appear in resulting query table
  3. To quickly manage the (un)selection of vast number of attributes you may use buttons:
    1. Check layer attributes
    2. Uncheck layer attributes
    3. Clear selection
    4. Delete




  1. Switch to Conditions tab
  2. Click Add new condition button
  3. Adds open or close brackets
  4. Clear all conditions
  5. Remove expression
  6. Select a layer
  7. Select a layer attribute
  8. Define conditions of SQL filtering



  1. Switch to SQL tab
  2. Verify SQL preview



  1. Switch to Query result tab, where the result appears