#317381- The issue with predicate generation for date is fixed.
- Provided Complex data binding Support.
- Provided Header Template Support.
- Provided model support for fields, operators and values.
#F162988- The issue when field has space is fixed.#317355- The issue with disable the condition option when that group has single
- Issue with angular template is fixed.
- Issue with template destroy is fixed.
- Issue with validation is fixed.
- Issue with Date Picker with null value is fixed.
#290596- Validation working improperly with column template issue resolved.- Issue with template destroy is fixed
- Issue with setting HTML element id start with number is fixed
- Issue with 'setRulesFromSql' method is fixed.
- Issue with changing value field width is fixed.
- Issue with 'getValues' method is fixed.
- Issue with 'setRulesFromSql' method is fixed.
- Issue with 'getColumn' method is fixed.
- Issue with persistence is fixed.
- Issue with 'boolean' type value is fixed.
- Issue with 'locale' is fixed.
- Provided
Rule Templatesupport.
- Issue with 'addGroups' method is fixed.
- Issue with 'setRulesFromSql' method is fixed.
- Issue with boolean value has been resolved.
- Issue with SQL parsing has been resolved.
- Issue with grouping after refreshing QueryBuilder has been resolved.
- Compatibility with EJ1 issues has been resolved.
- Provided
readonlysupport.
- Improvements in Value Template support.
- CSS validation issues has been resolved.
- Issue with predicate generation for date type is fixed.
| Property Name | Previous Type | Current Type |
|---|---|---|
| format | string | string |
- Provided the support to disable the combinator if only one rule is present.
- Issue with predicate generation for between operator is fixed.
- Issue with 'setRulesFromSql' method is fixed.
- Provided
NOTCondition support. - Provided Template support for Time Picker.
- Tooltip is not destroyed while using destroy method.
- Predicate is not created for Date type when between operator is fixed.
- Issue with changing 'number' type field is fixed.
- Provided Not Contains, Not Starts With and Not Ends With operator support.
- Value not updated properly while changing 'Between' operator.
- Value not updated properly while changing operator.
- Provided Null and Empty operator support.
- Date values are not properly filtered using DataManager.
- SQL Parsing issue when the rule contains 'Greater Than Or Equal', 'Less Than Or Equal' operator.
- Condition is not updated properly in the root while using 'setRules' method.
- Provided localization support for 'AND/OR' conditions.
- Selected value not maintained properly for radiobutton field.
- DataManager related issue resolved.
- Provided public method for get the rule by the rule Id.
- Date format issue in dd/mm/yyyy format.
- Selected value not maintained properly for radiobutton field.
- Provided
case sensitivesupport. - Provided default value option support for column fields.
- Provided groupBy support for columns.
- Updating conditions throws script error after using 'setRules' method.
- Rule with AND operator is not properly updated in ASP.NET MVC and Core.
- Multiselect datasource not properly updated for in and notin operators.
- Provided option for handling data source request on demand.
- Multiselect datasource not properly updated for in and notin operators.
- Rule with AND operator is not properly updated in ASP.NET MVC and Core.
- Updating conditions throws script error after using 'setRules' method.
- The following events are renamed.
| Existing Event Name | New Event Name |
|---|---|
| beforeConditionChange | beforeChange |
| beforeFieldChange | beforeChange |
| beforeOperatorChange | beforeChange |
| beforeValueChange | beforeChange |
| conditionChanged | change |
| fieldChanged | change |
| operatorChanged | change |
| valueChanged | change |
| groupDelete | change |
| groupInsert | change |
| ruleDelete | change |
| ruleInsert | change |
- Modified the return type of 'getFilteredRecords' method from object collection to promise.
- Renamed the 'RulesModel' class to 'RuleModel' and removed the 'RulesModel' class.
- Between Operator produces incorrect SQL is fixed.
- Issue with binding boolean values to radio button is fixed.
- Introduced new event 'RuleChange' which triggers once the current Rule is different from the older Rule.
- The following events are renamed.
| Existing Event Name | New Event Name |
|---|---|
| beforeConditionChange | beforeChange |
| beforeFieldChange | beforeChange |
| beforeOperatorChange | beforeChange |
| beforeValueChange | beforeChange |
| conditionChanged | change |
| fieldChanged | change |
| operatorChanged | change |
| valueChanged | change |
| groupDelete | change |
| groupInsert | change |
| ruleDelete | change |
| ruleInsert | change |
- Between Operator produces incorrect SQL is fixed.
- 'Add Group' option is not disabled while setting groupInsert as false is fixed.
- Provided
Summary viewsupport.
- Introduced validateFields method for validation.
The Query Builder component is a graphical user interface that allows users to create and edit filters. It outputs a structured JSON of filters which that can be easily parsed to create SQL. It is integrated with Data Manager to communicates with data sources and returns the desired result based on the provided filter. It supports data binding, templates, validation, and horizontal and vertical orientation.
-
Data binding: It auto populates the data source and maps the data to the appropriate fields.
-
Template: Supports templates and it is applicable for all input components.
-
Queries: Queries supports JSON/SQL rules.