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.
Working with several data models
Problem All EasyQuery demos works with one data model (and one database which corresponds to that model). However, some application might work with several databases and switch between them at run-time. The good news: starting from version 5.1.0 EasyQuery makes the task of switching between several data models quite simple.
Custom client-side dialogs for saving/loading operations
Problem The Advanced Search page in our demo project uses standard JavaScript prompt and confirm functions to get some data from the user or to ask for a confirmation. Is it possible to show some prettier custom dialogs instead of those default ones? The answer is yes and here we describe how to do it. Solution
Dynamic queries UI for ASP.NET Core projects with Entity Framework Core
Prerequisites Let's suppose we have: an ASP.NET Core project where we use Entity Framework Core to works with some database Pretty usual, yeah? Objectives We want: to create a view/page where our users can build custom (not predefined) queries to that DB and ... to run those queries over our DbContext to get the result sets. Solution
EasyQuery.JS widgets localization
Localization / internationalization tasks for EasyQuery widgets. How to add new locale, how to set current locale, how to switch widgets language on-the-fly.
Version 3.x tutorials (obsolete)
The tutorials for version 3.x branch of EasyQuery library
Exporting query results
Detailed instruction on how to perform additional functionality while dealing with EasyQuery results.
HAVING and GROUP BY clauses in generated query
This article shows how to add new clauses into the query and how to manage it
Paging in query results
Paging can make your work with query more convenient. And here is detailed instruction on how to use it.
Lookup fields and columns
How to deal with lookup fields in EasyQuery
Result grid formatting on the client-side
This article shows how to implement some particular tasks with your query
Add new operator into your data model
Here you can find all information needed to execute this task
Create virtual (calculated) attribute in you model
Virtual attributes: what are they for and how to add one
Gridview filtering with EasyQuery ASP.NET (WebForms)
Gridview filtering with EasyQuery ASP.NET (WebForms)
Attaching custom data with your query
Sometimes it's necessary to attach some additional data with each query and use that data on query execution. For example, user might want to specify some piece of text on the client-side and filter the result set on that text so only the rows that contains that text must be inlcuded in the result. 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:.