Tutorials

Previous versions' tutorials (obsolete)

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

Edit link dialog

Here you can find all necessary information of how to edit link dialog and how to add new conditions.

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.

How to save/load queries to/from database

Find out how to change this default behavior and save/load queries to any other storage

Query saving and loading

EasyQuery has built-in means for query saving and loading. Here we are going to describe the most common approaches for solving this task

JavaScript widgets formats and settings (Webforms)

How to set up column formats and change default settings of the table.

Customizing common SQL clauses

This article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)

Setup custom value editor — WinForms

Here you can find all steps you need to perfom

Customizing SQL query formats

Detailed instruction with various examples of how to operate with different query formats.

JavaScript widgets formats and settings (MVC version)

In this article, we describe the most common unique settings for EasyQuery JavaScript widgets and give examples of code.

Processing custom value editors in EasyQuery JS

Here you can find tips how to value editor setup and how to value editor widget

Processing custom value editors in EasyQuery JS

First, of you will need to assign a custom (user-defined) value editor for some attribute or operator in your data model. You have to ways to do it: Run Data Model Editor (DME). Select an entity attribute which you want to assign custom value editor to. You can add a custom editor to any entity attribute in your model at run-time. Here is an example of very simple value editor in TypeScript.

Possible ways of data model creation and loading

EasyQuery components need a [data model](/$aid/03bc06b0-83ec-4040-97ef-a50ca004177f) (a user-friendly representation of your DB) for their work. There are several different ways to create the model and load it on your project's startup. This article will describe all of them in detail.

ModelEditorForm class

Represents the main form of Data Model Editor

ModelReadWriteOptions enum

Represents different options used during data model loading or saving

ModelReadWriteOptions class

Represents different options used during data model loading or saving

Query class

Represents internal query structure.

DataModel class

Represents a data model

DataModel class

Represents a data model