1. Feedback
  2. JavaScript
  3. 41495

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, 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

Excel-style filtering with ODataV4 adaptor generates invalid OData query

Hi! I came across an issue with Excel-style filter in the grid along with OData adaptors. 

There's a generated "Blank" value in the checklist in the Excel-like filter (when the data contains null/undefined). When the user uses the checkbox to select it, the generated url includes a query for undefined - "$filter=((field eq null) or (field eq undefined))" -  which is invalid in OData.

The sample below uses ODataAdaptor because it was convenient to use that service, but it also happens in ODataV4Adaptor. The val=undefined predicate comes from the Excel filter.

https://stackblitz.com/edit/jujrb8?file=index.ts

Thanks,

Ashley