A Query object helps in the process of defining Database queries of an application. Every time an E3Browser or a Report object searches for data on a Database, users must send a command, so that they know which data is needed for that object. Therefore, every time an application needs to store or retrieve data from a Database, commands are sent in SQL (Structured Query Language) format. A Query features a friendly interface that allows building queries in a graphical form and an immediate preview of the generated SQL code. A Query allows showing data from the last N days, hours or months, final and initial date, and queries.
The Query wizard is responsible for creating a text that builds a filter or query, and users have no need to know details such as dates. To use this feature, follow these procedures:
1.Right-click a project's Screen and select the Insert - Standard - Query option.
NOTE |
When creating a Report or an E3Browser object, a Query object is automatically added to these objects. However, users can also insert this object on a Data Folder, on a Screen, on a Viewer, or on a Viewer Folder. For more details, please check the corresponding chapters. |
2.Before defining a Query, users must inform a Database Server that this Query uses to retrieve data. To do so, select a server on the Server Name combo box.
Defining a Database Server
Setting up a Query depends on the object to which it is linked.
Query settings
To check which settings are required for a Query, please check chapters Report and E3Browser.
Some of the properties of a Query can be configured using the Properties List, without creating scripts for this. To configure any property, locate it on the Properties List and perform the necessary adjustments. For more information, please check the E3 Reference and Scripts Manual.