User Tools

Site Tools


guide:help:pnldatatoolbarquerybuilder

Query builder

Documentation | Help File | UI | Panels | Data panel | Query builder

The Query builder is a component of the Data panel designed for records filtering. It provides the means for graphical creation of a query filter. When executed, only the records for which the query statement has the logical value TRUE remain visible within the records table.

Data panel Query builder displaying sample query.

To create a query filter

  1. Open the attributes table of the desired layer using the [ + ] button (see [+]) or the Show attributes table feature.
  2. Click on the icon on the Data panel Toolbar - this invokes the Query builder dialog box.
  3. Within the Query builder dialog box use the graphical tool to create the query filter.
  4. [OPTIONAL] Click on the Apply button to preview the result within the attributes table.
  5. Click on the OK button.

To use a query filter stored in a file

  1. Open the attributes table of the desired layer using the [ + ] button (see [+]) or the Show attributes table feature.
  2. Click on the icon on the Data panel Toolbar - this invokes the Query builder dialog box.
  3. Within the Query builder dialog box click on the Open… button - this invokes the Open an existing query dialog box.
  4. Within the Open an existing query dialog box select the appropriate drive from the Look in list.
  5. Locate the query filter file by entering the directory that contains this file.
  6. Double-click on the file name - this loads the query filter and brings back the Query builder dialog box.
  7. [OPTIONAL] Click on the Apply button to preview the result within the attributes table.
  8. Click on the OK button.

To save a query filter to a file

  1. Open the attributes table of the desired layer using the [ + ] button (see [+]) or the Show attributes table feature.
  2. Click on the icon on the Data panel Toolbar - this invokes the Query builder dialog box.
  3. Within the Query builder dialog box use the graphical tool to create the query filter.
  4. [OPTIONAL] Click on the Apply button to preview the result within the attributes table.
  5. Click on the Save As… button - this invokes the Save the active query to file dialog box.
  6. Within the Save the active query to file dialog box select the appropriate drive from the Save in list.
  7. Locate the folder where you would like to store the query filter file. A new folder can be created by clicking on the icon at the top-right corner of the Save the active query to file dialog box, entering its name and pressing the Enter key.
  8. Enter a name for the query filter file in the File name list.
  9. Click on the Save button - this brings back the Query builder dialog box.
  10. Click on the OK button.

To activate/deactivate a query filter, check/uncheck the checkbox on the blue field containing the query over the Data panel Toolbar.

To remove a query filter, click on the [X] button on the blue field containing the query over the Data panel Toolbar.

2018/06/05 12:28

Page Tools