Page History

...

...

Summary

A query is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs or complex results, e.g., trend analyses from data-mining tools.

...

This method is not as usual as the others, so more details regarding it functionalities will be detailed below.

...

How to use the Feature

Loading Data

Once you got your databases and providers configured correctly in the project, the first thing that needs to be done is to load the Data into the Query Builder.

...

If you wrote the right path, you should be able to see all available Tables and its elements on the right corner. Double-click on one of the Tables to load its elements into the Sub-Query Structure.

Loaded Tables

Properties

At the top-left corner, there is a Properties Button. When you select it, a popup will open with some customizable properties for the Query Builder.

In the image below all available properties are presented.

Query Builder Properties

Creating Statements

After one of the loaded tables is selected into the Sub-query Structure, you can see that a statement is initialized at the bottom of the page.

...

• Visible: Remove the column from the query result;
• Expression: Original column name;
• Column Name: Give a table, or a column in a table, a temporary Aliases are often used to make column names more readable. An alias only exists for the duration of the query.
• Sort Type: Sort the result-set in ascending or descending order.
• Sort Order: Sort columns order in result
• Aggregate: the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning. E.g.: Avg, Count, Sum.
• Grouping: Group column elements. Enable creating filtering conditions for groups or
• Criteria: Selection condition criteria. E.g.: =, >, <, ! =.
• Or: Same as the Criteria

Statement Example

To better illustrate the Query Builder feature, let’s create an example. Assuming the following requirements for our query result:

...