1. Feedback
  2. Angular
  3. 67466

Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Issue with setRulesFromSql in QueryBuilder – Fails on Valid SQL Syntax Without Parentheses in LIKE Clause

We would  like to bring to your attention an issue reported by a customer related to the setRulesFromSql method in the Syncfusion Angular QueryBuilder component.When using the LIKE operator in a SQL expression without parentheses, the setRulesFromSql method fails to parse the input, even though the SQL is valid and commonly used in natural syntax.

Currently, there is no built-in way to use the LIKE operator without parentheses in the setRulesFromSql method. The syntax with parentheses around the values (e.g., LIKE ('%HUDSON%') rather than LIKE '%HUDSON%') is the standard format supported by the Syncfusion Angular Query Builder component.

This doesn't work:
this.queryBuilder.setRulesFromSql("name LIKE '%HUDSON%'");

But this works:
this.queryBuilder.setRulesFromSql("name LIKE ('%HUDSON%')");


Sample : 

https://stackblitz.com/edit/angular-jcflwm-2pxsd4ex?file=src%2Fapp.component.ts


Replication : 

  • Run the sample 
  • Click the SetRuleFromSql button 
  • See the issue.

Expected : 

The setRulesFromSql method in Angular QueryBuilder should correctly parse valid SQL expressions using the LIKE operator without requiring parentheses. 

Current : 

The setRulesFromSql method fails to parse the SQL expression unless the value in the LIKE clause is enclosed in parentheses: