ComplexBinding Boolean Issue

[Chris Persichetti]

Hi,

There appears to be an issue with using boolean types for complex binding.

https://ej2.syncfusion.com/angular/documentation/query-builder/data-binding/#complex-data-binding

I'm unable to set the rules using setRulesFromSql.

For example I added BoolExample field:

this.columns1 = [

{ field: 'ID', label: 'ID', type: 'number'},

{ field: 'DOB', label: 'Date of birth', type: 'date'},

{ field: 'HireDate', label: 'Hire Date', type: 'date'},

{ field: 'Salary', label: 'Salary', type: 'number'},

{ field: 'Age', label: 'Age', type: 'number'},

{ field: 'Title', label: 'Title', type: 'string'},

{ field: 'BoolExample', label:'BoolExample', type: 'boolean', values: this.values}

] Then I updated

onSetSqlRules(e:Event): void {

this.qryBldrObj.setRulesFromSql("Employee.ID = 0 AND Employee.BoolExample = false Name.LastName LIKE ('%malan%') AND (Country.State.City LIKE ('U%') AND Country.Region LIKE ('%c') AND Country.Name IS NOT EMPTY)");

}

I'm unable to get the query builder to show the selected false value.

Thanks,

Chris

[Gayathri KarunaiAnandam]

Hi Chris, 

We have checked your reported query. We can reproduce your reported issue in our end. So, we have logged this issue as a bug, and it will be available in our upcoming patch release which will be scheduled on October 20^th,2021 and we appreciate your patience until then.   

You can also track the status of this bug by using our feedback portal link below.     

     

Feedback: https://www.syncfusion.com/feedback/29231/complex-data-binding-boolean-issue 

   

Please get back to us, if you need further assistance.   

Regards,   

Gayathri K   

[Sarasilmiya Shahul Hameed]

Getting access denied when trying to access: https://www.syncfusion.com/feedback/29231/complex-data-binding-boolean-issue Which was provided in: https://www.syncfusion.com/forums/169401/complexbinding-boolean-issue

[Gayathri KarunaiAnandam]

Hi Sarasilmiya, 

We have enabled the access to the below Feedback Portal link. Please check the below link. 

Feedback: https://www.syncfusion.com/feedback/29231/complex-data-binding-boolean-issue 

Please check and get back to us, if you need further assistance. 

Regards, 

Gayathri K