Previous versions' tutorials (obsolete)
/tutorials/version-3-x-tutorialsThis section contains the tutorials that we written for older versions of EasyQuery and most probably are obsolete now.
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:
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.
Date/time values formatting
/how-to/date-time-formattingIn this article, you can find instructions how to set up different types of date & time formats, with code examples.
Setup custom value editor — WinForms
/how-to/custom-value-editor-winformsHere you can find all steps you need to perfom
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
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
Dynamically populate value lists by information from other conditions
/how-to/dynamically-populating-lists-mvcSuppose we have a database with Customer entity which has Country and City attributes. For both these attributes we define the value editors which return the lists of available values (countries and cities correspondingly). Now let's imagine the user adds a condition with the Country attribute e.g. Hera the steps needed to implement such a functionality: Define a value editor for the City attribute as SQL LIST with Cities.@{{Customer.Country}} list name (here Customer.Country is the ID of the Country attribute in the Customer entity). Let's name it "CitesSqlValueList") and then in a value list resolver modify its SQL according the currently selected country and get the list of values using GetValueListAsync method of EasyQueryManager class: What's happening here.
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.
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
How to setup SQL LIST value editor in WinForms app
/how-to/SQL-LIST-value-editor-in-winforms-appStep-by-step instruction how to setup SQL LIST value editor.
Dynamic populating of value lists in WinForms or WPF editions
/how-to/dynamic-populating-value-list-winforms-wpfExample of how to solve this problem
Condition class
/api-reference-5x/korzh-easyquery-namespace/condition-classRepresents one condition in the query.
Utils class
/api-reference-5x/korzh-easyquery-namespace/utils-classRepresents different type conversion functions and other useful procedures
ValueEditor class
/api-reference-5x/korzh-easyquery-namespace/valueeditor-classRepresents an abstract value editor.
Utils class
/api-reference-4x/korzh-easyquery-namespace/utils-classRepresents different type conversion functions and other useful procedures
QueryFormats class
/api-reference-4x/korzh-easyquery-namespace/queryformats-classRepresents different formats of statements.
Condition class
/api-reference-4x/korzh-easyquery-namespace/condition-classRepresents one condition in the query.
QueryFormats class
/api-reference-5x/korzh-easyquery-namespace/queryformats-classRepresents different formats of statements.