Query Editor

Description:

You can create new fields for address or area layers.

You do this by generating queries that summarize the data from columns of existing data tables.

You can enter filters, calculation rules and conditions for a query.

You can also process a query at a later time. The query wizard to gives you an overview of the queries already defined for projects and helps you to create new queries or add new fields.

When creating a new query, you must first define a field. If no field is defined, the query cannot be saved.

Query editor can access by click on  button.

When creating a new query, you must first define a field. If no field is defined, the query cannot be saved.

Functionalities of following icons

Icons	Functionalities
	Create a new query or a new field.
	Copies a selected query or field.
	Delete the selected query or the selected field.
	Opens the query window for the selected field

Steps for creating new query

1. Open query editor window.

2. In the field Layer choose the layer in which to insert the table that will result from the new query.

3. Generate a new query by entering calculation criteria.

4. Click button to generate a query.

5. Choose the desired settings in the following tabs:

• General Tab
• Query tab
• Condition tab
• Constants tab

General Tab

In this tab, you determine the basis of a query.

In this tab, enter the basic details like field name, Aggregation of values and description.

1. In the Name field, enter a name for the new field.

2. Select the calculation parameter from Aggregation of values list. 

Calculation parameters	Description
Total	adds the contents of the selected field
Average	calculates the average of the field contents
Number of	shows the number of data records
Minimum	Shows the smallest field content
Maximum	Shows the largest field content
First entry	Shows the first entry
Last entry	shows the last entry

3. If required, enable 'Generate text query'.

  After enable this option, values on the aggregation of values are charging to

Element	Description
Number	Shows the number of data record
First entry	Shows the first entry
Last entry	Shows the last entry

4. Enter a description in the field.

5. Click on button or switch to next tabs Query/condition/constants.

 Query Tab

In this tab choose the tables and the fields to include in the query. 

Defining field with text queries

 1. In the General tab, activate the option Generate text query.

2. In the Query tab, choose the table and the field to be included in the query.

3. Click on Generate button.

Defining field with numerical queries

User can create numeric queries by select proper fields and required operator.

1. In the Query tab, choose the table and the field to be included in the query.

2. Enter the desired operators and brackets.

3. Test your entries with confirm button. 

4. Click on button

Condition Tab

In addition to the query, Query tab, you can also enter a condition to have the formula include only entries for which this condition applies.

You can enter the query by selecting the desired data table and field from lists.

The list of tables contain an entry for each available data table with the name of the particular layer followed by a comma and the name of the data table.

1. In the General tab, enter field name and aggregate value.

2. In the Query tab, choose the desired settings.

3. In the Condition tab, enter the desired settings for the query:

Interfacing	Description
AND	Both conditions must be satisfied for the entry.
OR	One of the two conditions must be fulfilled for the entry to be taken into account.
AND NOT	The first condition must be fulfilled and the second may not be fulfilled for the entry to be included.
OR NOT	If the first condition is fulfilled or if the second is not fulfilled or if both apply the entry is included.

• Test your entries with confirm button.
• Generate query.

Constants

You can add numerical queries to a view, Query tab. The entries are calculated in this case using a formula which you can define.

If you require a constant for your formula you must define it beforehand. For example, if you are performing a percentage calculation, you must define the value 100 as a constant.

This constants are listed in table drop down list and able select proper ones.

Do the following steps to create new constant

1. Enter the name and value of the constant.

2. Click on button.