We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grid filtering mixing two filter types (Excel and FilterBar)

Thread ID:





145228 Jun 13,2019 05:21 AM UTC Jun 17,2019 09:38 AM UTC Angular - EJ 2 1
Tags: Grid
Asked On June 13, 2019 05:21 AM UTC


In my application I am using two filter types - Excel and FilterBar.

If I as using them together I think it sends wrong where predicates to WebAPI (I am using remote data). I can reproduce this here: https://stackblitz.com/edit/angular-a6zcre?file=app.component.ts

For example:
1. Select in Excel type filter something in Customer Name column.

2. Change filter type to FilterBar (first problem I think that I can see in FilterBar column Customer Name already selected value (one value when I selected for example two different value)).

Typing something:

3. Type something in for example Ship Country column. And we can see that no records are displayed.

In this case in my application I can see that data was sent to WebAPI in this structure (ItemCategoryCode was set in Excel type filter, other data was set in FilterBar type filter):

I think it should be sent to WebAPI in this sructure:

By the way - if first of all I set something in FilterBar type filter and then in Excel type filter - data are sent to WebAPI with correct structure.

Pavithra Subramaniyam [Syncfusion]
Replied On June 17, 2019 09:38 AM UTC

Hi AC, 

Thanks for contacting Syncfusion support. 

By default, Excel filter works for complex filtering but filterBar does not work for complex predicate and it handle only single value in Grid. When dynamically change to filter type then it does not generate predicate based on that type because we have already generated the predicate for those filtered columns. We suggest you to clear the filter before changing the filter type to resolve the problem. 

Pavithra S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon