Data Model
/fundamentals/data-modelIn 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:
Building dynamic queries with EasyQuery and Entity Framework
/tutorials/dynamic-queries-with-easyquery-and-entity-frameworkHere we describe how EasyQuery helps to implement a query building UI for creating custom, dynamic queries in .NET projects which use Entity Framework (6.x)
Introduction to value editors
/fundamentals/about-data-editorsFor example, value editor allows you to define a list of available values - so your users will be able to select the value from a drop-down list. "Custom list" value editor raises an event which can be processed either on the client-side or on the server. All other editions of EasyQuery (WinForms, WebForms, WPF or Silverlight) has ListRequest event in QueryPanel control which is raised when a user adds an attribute (or operator) with Custom List or SQL list value editor assigned to that attribute/operator. Here we show how you can filter the returned list according to the value specified for some other attribute. If such condition is defined - we get the value (country code) from it and use that value as a filter for the list of regions.
Create virtual (calculated) attribute in you model
/tutorials/add-virtual-attribute-in-modelVirtual attributes: what are they for and how to add one
Entities page
/data-model-editor/entities-pageThis page describes entities participating in the data model and their attributes.
Processing custom value editors in EasyQuery JS
/how-to/custom-value-editorHere you can find tips how to value editor setup and how to value editor widget
How it works
/fundamentals/how-it-worksThe above scheme shows the general internal structure of the library and the main principles of its work. EasyQuery components All EasyQuery classes and components can be divided into two main parts: logical part (DataModel, Query, SqlQueryBuilder). the visual part (QueryPanel, ColumnsPanel, etc.). The logical part is responsible for the internal representation of data structures and user
Edit link dialog
/data-model-editor/edit-link-dialogHere you can find all necessary information of how to edit link dialog and how to add new conditions.
Gridview filtering with EasyQuery ASP.NET (WebForms)
/use-cases/gridview-filtering-with-easyquery-aspnet-webformsGridview filtering with EasyQuery ASP.NET (WebForms)
Building data model dynamically by information from a DataTable
/how-to/build-data-model-by-info-from-datatableExample of how to build data model by certain information from DataTable
Adding a new operator to your data model
/tutorials/add-new-operatorHere you can find all information about how to add a new operator to your data model either using Data Model Editor (DME) or with a code
Getting started for EasyQuery ASP.NET MVC
/getting-started/version-3-x/asp-net-mvcThis article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application
Customizing SQL query formats
/how-to/customizing-sql-query-formatsDetailed instruction with various examples of how to operate with different query formats.
Navigate through query conditions
/how-to/run-through-query-conditionsA code snippet which demonstrates how to run through all conditions in your query
User-friendly name for tables
/how-to/user-friendly-name-for-tablesSome tips for choosing right “entities” and their “attributes”
Building data model dynamically by DB meta-information
/how-to/build-data-model-by-db-meta-informationIt's easier to fill your model right in the code directly from your database, using meta-information
Generating queries for 2 (or more) databases
/how-to/querying-several-databasesHere you can find tricks for executing this task
Setup custom value editor — WinForms
/how-to/custom-value-editor-winformsHere you can find all steps you need to perfom
Getting started for ASP.NET WebForms
/version-3-x/getting-started/asp-net-webformsHere you can find the instructions how to add EasyQuery components into your ASP.NET WebForms project
Operators page
/data-model-editor/operators-pageThis article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).
Lookup fields and columns
/tutorials/lookup-fields-columnsHow to deal with lookup fields in EasyQuery
Hide some entities and/or attributes
/how-to/hide-entities-and-attributesHere we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model
Add a new aggregate function
/how-to/add-aggregate-functionEasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.
Terminology
/fundamentals/terminologyCommon terms Database - may refer to any data storage but in most cases we mean some relational database such as MS SQL Server, My SQL, Oracle, etc. Result set - a result of some search request (query). Usually, is presented as tabular data. Query - a search request. Query condition - one of the search terms (for example: "Customer name starts with 'A'")
About Data Model Editor
/data-model-editor/aboutHere you can find detailed information about this instrument and guideline, how to use it to perform all needed tasks.
Tables and links page
/data-model-editor/tables-links-pageLearn how to work with tables and links within your Data Model, change and edit them.
Upgrading from version 2.x to 3.0
/release-notes/upgrade-from-2.x-to-3.0How to upgrade your project from version 2.x to version 3.0 of EasyQuery
Dynamic PHP query builder with EasyQuery
/use-cases/dynamic-php-query-builder-with-easyqueryDynamic PHP query builder with EasyQuery
Replace "value" element in QueryPanel's conditions — WinForms
/how-to/replace-value-elementHere is a step-by-step description what you need to achieve this goal
Building data model dynamically using code (version 3.x)
/how-to/build-data-model-by-codeHere you can find all steps you need to perform
How to add a column with the same attribute as in newly added condition
/how-to/add-column-by-condition-attributeA code snippet which demonstrates how to do this task
How to limit columns from duplication
/how-to/how-to-limit-columns-from-duplicationHow 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.
How to show descriptive texts in some column instead of numeric values
/how-to/descriptive-texts-in-column-instead-numeric-valuesHow to show some descriptive texts for some column in result set instead of actual numeric values stored in DB
Working with data models in EasyQuery
/getting-started/working-with-data-modelThis article will guide you through all issues about working with data models in EasyQuery library. How to load it from the DbContext or from your DB connection, or now to create a new one using Data Model Editor.
Navigate through data model entities and attributes
/how-to/run-through-data-model-entitiesA code snippet which demonstrates how to run through data model entities and attributes
How to make a field to field comparison
/how-to/field-to-field-comparisonThe instructions on how to add a condition which compares a field against another field instead of constant value.
Working with table aliases
/data-model-editor/working-with-aliasesIn this article, we provide all the information needed to use aliases properly. There is an explanation, what for aliases are in the DME and an example of using it.
Using parameters in query conditions
/how-to/parameters-in-query-conditionsThis article explains how to work with parameterized conditions.
Adding columns and conditions with code
/how-to/add-columns-conditions-with-codeExample of code for adding columns and conditions
Value Editors
/data-model-editor/value-editorsHere you can find the full list of editors and choose any you need in your work with Data Model:
Processing custom value editors in EasyQuery JS
/how-to/processing-custom-value-editors-in-easyquery-jsFirst, 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.
Getting started for Silverlight
/getting-started/silverlightThis article will guide you through all steps necessary to apply EasyQuery.NET to your application, with extract examples
Getting started for WPF
/getting-started/version-3-x/wpfYou will be able to apply EasyQuery WPF to your application, performing all the instructions in this article
Localization of EasyQuery widgets (obsolete)
/tutorials/version-3-x/javascript-widgets-localizationThis article shows how to localize widgets, with extract examples
How to add an extra condition to your query
/how-to/add-extra-conditionTwo possible ways of resolving this task