Creating a query

To create a new query, right-click on the Products database schema and then select the New - Create query function from the context menu. A window appears where you will need to enter a name for the query.

In our example the name of the query will be Product_by_category.

The query will appear in the tree structure below the database schema. The query editor looks like the following when the wizard mode checkbox is selected:

A query includes the following tabs:

• Multiple rules by which the results table will be evaluated can be specified on the Conditions tab.
• The Parameters lists all parameters that are used in this query and can be populated with fixed values, if required.
• All result datasets that result from the conditions in the query and query parameter value assignment are output in the Results tab.
• Only the result datasets with the "released" status are output in the Result (release... tab.