Queries

<< Click to Display Table of Contents >>

 

Queries

A Query object helps in the process of defining queries in an application's database. Every time E3 needs to search for data in a database, users must send a command so that the query knows which data is needed for that object. For this search, every time an application needs to store or search for data in a database, it sends commands in SQL (Structured Query Language) format.

A Query presents a friendly interface that allows building SQL queries using a graphical interface and then following the immediate results of the generated SQL code. A Query allows showing the last data from n days, hours, or months, starting and ending date, and queries, depending on the implemented filter.

The Query Configuration Wizard is responsible for creating the text that performs a filter or query, but users do not need to know implementation details, such as dates. To use this resource, right-click a project's Screen and select the Insert - Query option.

 

NOTE

When creating a Report or an E3Browser object, a Query object is automatically added to it. However, users can insert a Query in a Data Folder or on a Screen and use its data via scripts.

Was this page useful?