Excel Style Filtering Trouble

[Bernd]

Hi,

I use Excel style filtering with the SfDataGrid, but unlike Excel the available checkboxes are built from the filtered items not from all items.

Steps to reproduce:

I have a column with values "Europe" and "USA".

1) Open the filter and see two unchecked checkboxes for Europe and USA
2) Apply a filter for "Europe"
3) Open the filter popup the second time and only see one (!) checked checkboxs for "Europe" but I would expect to also see a second unchecked checkbox for "USA"

IS this behaviour configurable or how do I come by to achieve it?

Regards
Bernd

[Sowndaiyan Paulpandi]

Hi Bernd,

Thank you for contacting Syncfusion support. 

We have checked your reported issue and also we have prepared the sample as per your scenario. But we were not able to reproduce the reported issue. For your reference we have attached the tested sample and video in the below location. Please revert by modifying the attached sample based on your application and also share the details about which Syncfusion product version you have used in your application. It will be helpful for us to analyze further. 

Sample : http://www.syncfusion.com/downloads/support/forum/125103/ze/Filter-2089729588 

Video : http://www.syncfusion.com/downloads/support/forum/125103/ze/Filter1-1764931846 

Regards,

Sowndaiyan

[Bernd]

Sowndaiya,

thank you for the sample which is of course working. :-) After checking the deifferences between your an my implementation I realized that my Grids are fed from an Entity Framework datasource, so the ObservableCollection contains DynamicProxies which looks like it makes the difference. As soon as I feed my ObservableCollection manually with standard objects my grids work just as expected.

So how can I solve this?

Regards
Bernd

[Sowndaiyan Paulpandi]

Hi Bernd,

We have checked your reported issue with Entity collection and the SfDataGrid filter popup is properly loaded the all records after filtering the particular column. So could you please modify the below sample as per your application and revert back to us. It will be helpful for us to analyze further.

Our tested Entity Collection sample :

http://www.syncfusion.com/downloads/support/directtrac/ze/EntityFrameworkBinding_Demo463938980


Regards,

Sowndaiyan

[Bernd]

Sowndaiya,

the proble in my case are the DynamicProxies of my model objects. If I programatically set ctx.Configuration.ProxyCreationEnabled = false; then I get normal model entities instead of dynamic proxies and the filter works as expected. But I cannot do that because I would loose lazy loading and automated change tracking.

Find attached a demo to demonstrate the behaviour. It uses a MSSQLLocalDb Database instead of a MDF.

Regards
Bernd

Attachment: EntityFrameworkBinding_DemoNotWorking_55f5c8ec.zip

[Sowndaiyan Paulpandi]

Hi Bernd,

We have checked your query and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.  

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents   

Regards,

Sowndaiyan