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:

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