A Query is an E3 object that helps users in the process of defining queries on an application database. Every time an E3Browser retrieves data from a database, users must send a command to know which data is needed for that object. Therefore, every time an E3 application needs to store or retrieve data from a database, these commands are sent in SQL (Structured Query Language) format.
Query in an E3Browser object
A Query presents a friendly interface, allowing users to build queries in a graphical form and immediately displaying the generated SQL code.
NOTE |
An E3Browser cannot load Queries located on a server. |
The Query tab shows all available fields in a Query. These fields can be accessed by clicking Configure, which opens a wizard to configure that Query.
Query tab
For more information on Queries, please check the Query chapter.