Tutorials

Attaching extra data to a query on the client-side

Sometimes it's necessary to attach some extra data to each query (based on some user's input on the client-side) and then use that extra data on query execution. For example, user might want to specify a date (or a period of time) as an additional filter to the any query. To add some extra data you can use beforeExecuteQuery event handler which can be defined on view initialization: Now if you check in Developer Tools (on Network tab), each .../execute request now includes ad additional data object in the request payload. Now to process this additional request data you can create your own implementation of EasyQueryManager and override its ExecuteQueryCore method. Here is an example: Here we just reconfigure our current query and add in it an additional condition group with a bunch of conditions like SomeColumns contains 'filter text' Finally, you need to register your manager class on EasyQuery middleware initialization: NB: Please note that you can read the ClientData property in any method of your custom manager.

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: AdvancedSearchView ReportView DataFilterView

Build query by code on the client-side

Here you can find an example of JavaScript code with explanation how to add columns to a current query on client-side.

Previous versions' tutorials (obsolete)

This section contains the tutorials that we written for older versions of EasyQuery and most probably are obsolete now.

How to add an extra condition to your query

Two possible ways of resolving this task

Aggregate data

From this article you will see how to aggregate (count, sum, etc.) data in your queries.

Query with a subquery

How to build queries with subqueries using EasyQuery.

Query with OR operators

In this article, you will learn how to build queries that contain both AND and OR operators.

Managing data formats

This article shows how to implement some particular tasks with your query

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. Any data model contains the following main sections:

Create a query with sub-query by code

Example with code

Data Model Editor

Common SQL queries

Custom client-side dialogs

Users who use some other dialogs libary usually want to replace those default dialogs with their own. We are going to replace those default dialogs with nice HTML dialogs made with JQuery UI dialogs library. The approach we will use is quite simple: our AdvancedSearchView JavaScript class has several methods which can be "overriden" to replace the default behavior with your own implemenation of those dialogs. In case of using JQuery dialogs we need to define some placeholders (read div elements) on our page where our new dialogs will be rendered. Here is an example: NB: Please note that this step is specific for JQuery dialogs.

Query.Error class

Query exception class.

Query class

Represents internal query structure.

Query with table joins

An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.

About Data Model Editor

Here you can find detailed information about this instrument and guideline, how to use it to perform all needed tasks.

Store queries in a database

Here we describe the case when all users of some web application create their own queries and would like to store those queries in some database.