No rows seem to match when using GridExcelFilter on GridGroupingControl

[Stephen New]

Hi,

I am having an issue when I used the GridExcelFilter as the column filter for my GridGroupingControl. When I used the filter to select any column value...then no rows are displayed at all!

I have attached a simple example where I have:

* Populated a GridGroupingControl with a List<T>

* Enabled AllowFilter for each of the columns

* Wired up a GridExcelFilter to the GridGroupingControl

See attached zip file (GroupingGridWithExcelFilters.zip)

When I run the application, filter on a column value, no rows are displayed at all.

Can someone please explain to me why the rows are not filtered according to the chosen filter value?

Regards,

Stephen

Attachment: GroupingGridWithExcelFilters_6298e7b5.zip

[Neelakandan Kannan]

Hi Stephen,

 

Thank you for using Syncfusion products.

 

We can also reproduce your reported scenario at our end. The reported issue with “Filtering not performed”  has been occurred due to the MappingName and Name properties of the ColumnDescriptor. If you want to set the Name property for the column descriptor, the name should be like MappingName. For more details, please refer the below description for the MappingName and Name properties.

 

MappingName description:

 

Name description:

 

Here we have provided the modified sample and code snippet. Please make use of it.

 

Code Snippet:

gridColumnDescriptor1.MappingName = "ColumnAField";

//The name and mapping name should be same when you specify the name for column

gridColumnDescriptor1.Name = "ColumnAField";

 

gridColumnDescriptor2.MappingName = "ColumnBField";

//The name and mapping name should be same when you specify the name for column

gridColumnDescriptor2.Name = "ColumnBField";

 

Modified Sample:

http://www.syncfusion.com/downloads/support/forum/119325/ze/Modified_Sample1821257024

 

Please let me know if you have any concerns.

 

Regards,

Neelakandan

[Stephen New]

Thanks very much, Neelakandan. That solved my problem.

[Neelakandan Kannan]

Hi Stephen,

Thank you for your update.

We are glad to hear from you that your scenario has been achieved.

Please let us know if you need further assistance on this.

Regards,
Neelakandan