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.
Unfortunately, activation email could not send to your email. Please try again.

Event after Filter (e.g. via GridExcelFilter) is applied ?

Thread ID:

Created:

Updated:

Platform:

Replies:

109631 Jun 24,2013 05:38 PM Sep 3,2013 12:28 AM Windows Forms 13
loading
Tags: Grouping
Markus Loibl
Asked On June 24, 2013 05:38 PM

Hello,

is there an event AFTER the filter is applied?

I've tested

grid1.TableDescriptor.RecordFilters.Changed += RecordFilters_Changed

but it wasn't fired after all the data was filtered, but before.


Vinish Kumar K [Syncfusion]
Replied On July 1, 2013 02:26 AM

Hi Markus,

 

Thank you for your interested in Syncfusion products.

 

We have analyzed the reported issue in our current version 11.2.0.21. and RecordFilter.Changed event is fires after the data is filtered and please provide the sample file which is reproduce the issue in your end and please provide the Syncfusion essential studio version details which is you have used. This will help me to provide proper response for the reported issue.

 Please refer the attached sample file for further reference.

Please let me know if you have any concerns.

 

Regards,

Vinish.



CS_7bf508b1.zip

Markus Loibl
Replied On July 1, 2013 01:14 PM

Hi,

thanks for your sample.

However if I change GridOffice2007Filter to GridExcelFilter it doesn't work any more: the event isn't thrown any more

 

 

 

 

 

 

 



CS1096312_1c8e5bdb.zip

Markus Loibl
Replied On July 1, 2013 01:24 PM

The Problem with GridOffice2007Filter  is that it is too slow sometimes


Vinish Kumar K [Syncfusion]
Replied On July 7, 2013 11:16 PM

Hi Markus Loibl,

 

Thank you for your update.

 

Sorry for the inconvenience caused with delay. The office2007  filter is slow while loading the large data set. So that we have implement the Excel filter in our source, so we have suggested you to use the GridExcelFilter in  your application. It provide the all filter option like excel.

 

Please let me know if you need any help regarding excel filter, we will provide solution for this.

 

Regards,

Vinish K.


Markus Loibl
Replied On July 9, 2013 03:34 PM

Please download the sample from me, two Posts before this or so. The events are not fired!


Vinish Kumar K [Syncfusion]
Replied On July 15, 2013 11:44 PM

Hi Markus Loibl,

Thank you for your update,

Currently we are working on this query to provide the solution, we will update the details to you  on July 17, 2013.

Appreciate your patience.

Regards,
vinish K

Markus Loibl
Replied On August 18, 2013 01:33 PM

Any news?


Vinish Kumar K [Syncfusion]
Replied On August 22, 2013 01:07 AM

Hi Markus

 

Sorry for the inconvenience caused

 

Query

Event in GridExcellike filter

We have analyzed the reported issue in our end. We have implemented the two new event to fire as per your requirement in GridExcelFilter.

 

Please use the following event instead of recordFilter.Changed event.

 

 

filter.RecordFiltersItemChanged += new Syncfusion.Collections.ListPropertyChangedEventHandler(filter_RecordFiltersItemChanged);

             

filter.RecordFiltersItemChanging += new Syncfusion.Collections.ListPropertyChangedEventHandler(filter_RecordFiltersItemChanging);             

 

please let me know if you have any concerns. We will provide the proper details asap.

 

Thanks

Vinish K


Markus Loibl
Replied On August 27, 2013 04:47 AM

Sorry, it does not work as expected.  I still use version 11.2040.0.25, is that ok?

  • Clearing the filter doesn't throw any of these Events
  • The Event is coming too early.
    I use this function:
        var filtered = gridGroupingControlRestaurants.Table.FilteredRecords;
    The result DataTable is still the one as BEFORE the filter was changed!
    What I need is the ACTUAL DataTable!

 

Markus

 



Markus Loibl
Replied On August 27, 2013 08:40 AM

I extended and simplified your sample. See the attachment.

step1.png shows setting a filter.
step2.png Shows the wrong result within the Events: 2 elements are in the grid, 20 are counted !!

 



filterSample_22a0ef89.zip

Markus Loibl
Replied On August 27, 2013 03:01 PM

Another modification (and workaround?):

If the events you describe each starts a timer, and handling this timers' dowork-event, then I get the correct results.
I think ist because then all grid-internal work is done ...



FilterProblem2_51a88b9a.zip

Vinish Kumar K [Syncfusion]
Replied On September 3, 2013 12:28 AM

Hi

We have analyzed the reported query with provided information, this will help us to know more details about your actual issue, already we have suggested some other events based on our internal grid architecture.

So please handle the code which is provided along with your solution to get better solution.

We will analyze the provided information with internal source and we will provide if it is possible to move the changes internally.

Regards,
Vinish K

Vinish Kumar K [Syncfusion]
Replied On September 3, 2013 12:28 AM

Hi

We have analyzed the reported query with provided information, this will help us to know more details about your actual issue, already we have suggested some other events based on our internal grid architecture.

So please handle the code which is provided along with your solution to get better solution.

We will analyze the provided information with internal source and we will provide if it is possible to move the changes internally.

Regards,
Vinish K

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.

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.

;