Customizing common SQL clauses
/how-to/customizing-common-sql-clausesThis article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)
Customizing SQL query formats
/how-to/customizing-sql-query-formatsDetailed instruction with various examples of how to operate with different query formats.
HAVING and GROUP BY clauses in generated query
/tutorials/having-group-by-clausesThis article shows how to add new clauses into the query and how to manage it
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
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 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.
Using MS SQL instead of Access in WebDemo sample project
/getting-started/sample-webforms-change-to-mssqlIn this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access
Custom client-side dialogs
/tutorials/custom-javascript-dialogs-saving-loadingUsers who use some other dialogs libary usually want to replace those default dialogs with their own. We are going to replace those default dialogs with nice HTML dialogs made with JQuery UI dialogs library. The approach we will use is quite simple: our AdvancedSearchView JavaScript class has several methods which can be "overriden" to replace the default behavior with your own implemenation of those dialogs. In case of using JQuery dialogs we need to define some placeholders (read div elements) on our page where our new dialogs will be rendered. Here is an example: NB: Please note that this step is specific for JQuery dialogs.
SqlStatement class
/api-reference-5x/korzh-easyquery-db-namespace/sqlstatement-classRepresents the result of performing BuildSQL command.
EntitySqlStatement class
/api-reference-4x/korzh-easyquery-db-namespace/entitysqlstatement-classRepresents the result of performing BuildSQL command.
EntitySqlStatement class
/api-reference-5x/korzh-easyquery-db-namespace/entitysqlstatement-classRepresents the result of performing BuildSQL command.
SqlStatement class
/api-reference-4x/korzh-easyquery-db-namespace/sqlstatement-classRepresents the result of performing BuildSQL command.
SqlStatement class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/sqlstatement-classRepresents the result of performing BuildSQL command.
SqlFormats class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/sqlformats-classRepresents different formats of SQL statements.
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.
DbQueryFormats class
/api-reference-4x/korzh-easyquery-db-namespace/dbqueryformats-classRepresents different formats of SQL statements.
DbQueryFormats class
/api-reference-5x/korzh-easyquery-db-namespace/dbqueryformats-classRepresents different formats of SQL statements.