Query Generator Window
Use the Query Generator
window to define and create your own queries. Select tables and fields on the left, conditions and variables on the right of the window.
The Tables Area
Use this area to select as many tables as you need for your query. When you select a table, its fields immediately appear in the Fields
area.
Fields that are related to other tables are displayed in bold typeface. You can add the related table to the list of selected tables by dragging the related field to the Tables
area.
The Fields Area
The Fields
area includes two columns: Name and Description. In the resulting report, field descriptions are used as the field titles.
The Query Area
Displays selected fields separated by commas. The fields in this area appear with a T0, T1, ... T If you specify a field manually:
|
Displays selected tables for the query. The application assigns the prefix number according to the order in which the tables were selected. |
The area where the query conditions are defined and formulated. |
Define how to sort the query results.
You create a query that lists the numbers of all sales quotations
created by specific users for specific customers. To sort the query results
by user, specify the End of the example. |
Example|
Group the query results according to specific criteria.
You want to create a query that lists the customers to whom sales quotations were issued during a defined period. In this case, you group by customer code, so that each customer appears once, regardless of the number of sales quotations issued to each one. End of the example. |
Opens the |