Common terms Database - may refer to any data storage but in most cases we mean some relational database such as MS SQL Server, My SQL, Oracle, etc. Result set - a result of some search request (query). Usually, is presented as tabular data. Query - a search request. Query condition - one of the search terms (for example: "Customer name starts with 'A'")

How it works

The above scheme shows the general internal structure of the library and the main principles of its work. EasyQuery components All EasyQuery classes and components can be divided into two main parts: logical part (DataModel, Query, SqlQueryBuilder). the visual part (QueryPanel, ColumnsPanel, etc.). The logical part is responsible for the internal representation of data structures and user

Data Model

In short (and by its name), data model - is a model (representation) of some data stored in your database. It solves two major problems: Presents the data to the end user in a more friendly and familiar way. Contains some meta information that helps EasyQuery components to build query statements in SQL or other query languages

Introduction to value editors

Each condition in query consists of 3 parts: attribute (field), operator and values (one or more). By default when a user clicks on ”[enter value]” link in a condition he/she is presented with an edit box actually to type the value. EasyQuery allows you to assign a value editor for each attribute or operator in your model - so your users will be able to use other methods of entering values

EasyQuery client-side views

Starting from version 5.0 EasyQuery.JS introduces the concept of a view . "View" - is a set of different EasyQuery widgets assembled to work together on some web page to cover a particular use-case. There are several views available out-of-the-box: 1. Advanced Search view AdvancedSearchViewJQuery 2. Report view ReportViewJQuery 3. Data-filter view DataFilterViewJQuery NB: