Tutorials

Adding columns and conditions with code

Example of code for adding columns and conditions

Previous versions' tutorials (obsolete)

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

Column class

Represents some column which will be queried.

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

A code snippet which demonstrates how to do this task

Column class

Represents some column which will be queried.

How to add an extra condition to your query

Two possible ways of resolving this task

Condition class

Represents one condition in the query.

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.

Condition.LinkType enum

Represents type of linking of conditions in group

Lookup fields and columns

How to deal with lookup fields in EasyQuery

Condition class

Represents one condition in the query.

Condition class

Represents one condition in the query.

TableLink.Condition class

Represents linking condition

Navigate through query conditions

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

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.

Create a query with sub-query by code

Example with code

Using parameters in query conditions

This article explains how to work with parameterized conditions.

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.

Copying the EasyQuery's code from a sample to your project

If you have already modified one of our sample projects to make it work with your DB, the next step will be to copy the EasyQuery's code to your own solution. This article describes how to do it.