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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel Style Filtering Trouble

Thread ID:

Created:

Updated:

Platform:

Replies:

125103 Jul 21,2016 04:24 PM UTC Jul 28,2016 11:52 AM UTC WPF 5
loading
Tags: SfDataGrid
Bernd
Asked On July 21, 2016 04:24 PM UTC

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 [Syncfusion]
Replied On July 22, 2016 01:31 PM UTC

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
 

Regards,

Sowndaiyan


Bernd
Replied On July 22, 2016 11:11 PM UTC

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 [Syncfusion]
Replied On July 26, 2016 12:35 PM UTC

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
Replied On July 27, 2016 09:35 PM UTC

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 [Syncfusion]
Replied On July 28, 2016 11:52 AM UTC

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.  
Regards,

Sowndaiyan


CONFIRMATION

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.

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

;