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 the filter or the query, but users do not need to know implementation details such as dates, etc. 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?