How to

How to setup SQL LIST value editor in WinForms app

Step-by-step instruction how to setup SQL LIST value editor.

How to make field to field comparison

The instructions on how to add a condition which compares a field against another field instead of constant value.

Setting anti-forgery token for AJAX requests from EasyQuery widgets

Here you can find out how to strengthen security of your project using antiForgeryToken option.

User-friendly name for tables

Some tips for choosing right “entities” and their “attributes”

Building data model dynamically by information from DataTable

Example of how to build data model by certain information from DataTable

Building data model dynamically by code

Here you can find all steps you need to perform

Building data model dynamically by DB meta-information

It's easier to fill your model right in the code directly from your database, using meta-information

Add columns and conditions by code

Example of code for adding columns and conditions

Add an extra condition to your query

Two possible ways of resolving this task

Create a query with sub-query by code

Example with code

Navigate through query conditions

A code snippet which demonstrates how to run through all conditions in your query

Navigate through data model entities and attributes

A code snippet which demonstrates how to run through data model entities and attributes

Generating queries for 2 (or more) databases

Here you can find tricks for executing this task

Setup custom value editor — WinForms

Here you can find all steps you need to perfom

Replace "value" element in QueryPanel's conditions — WinForms

Here is a step-by-step description what you need to achieve this goal

Hide some entities and/or attributes

Here we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model

Dynamically populate lists by information from other conditions — WinForms

Example of how to solve this problem

Dynamically populate lists by information from other conditions — WebForms

A code snippet which demonstrates how to execute this task

Add query builder page from our MVC sample project in your own app

This article described how to set up an advanced search page in your web-application using EqMvcDemoDB project as a template.

How to add a column with the same attribute as in newly added condition

A code snippet which demonstrates how to do this task

Processing custom value editors in EasyQuery JS

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

How to save/load queries to/from database

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

Add a new aggregate function

EasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.

Using parameters in query conditions

This article explains how to work with parameterized conditions.

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.

How to remove "Powered by..." link (full version only)

Full instruction of how to remove “Powered by EasyQuery” link

How to limit columns from duplication

How to limit columns from duplication in MVC project, so when you add a column that is already used in a report it won’t be added again.

Date/time values formatting

In this article, you can find instructions how to set up different types of date & time formats, with code examples.

Customizing common SQL clauses

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

Adhoc reporting page in your web application

This article describes how to implement the adhoc reporting functionality (similar to the one from our live demos) in your own project.

Customizing SQL query formats

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

How to show descriptive texts in some column instead of numeric values

How to show some descriptive texts for some column in result set instead of actual numeric values stored in DB