Get and Set Filter

Question

I am trying to get any current filter set by the user before refreshing the grid, so that I can reapply the filter after refreshing the grid... I've set the filter like so (only seeing Line = 2):

Yet when I try and get the filter:

Dim rfdc As New Syncfusion.GridHelperClasses.GridDynamicFilter

rfdc = sfgrdLines.TableDescriptor.RecordFilters

It tells me the filter count is zero. I'm new to Syncfusion... Apologies if I'm missing something obvious!

Thanks

Sindhu Nagarajan · Answer

Hi Andrew,

Thanks for contacting Syncfusion support.

We have analyzed your scenario and it can be achieved by serialize/de-serialize the filtered records. The GridGroupingControl has the support to serialize the filtered record using GridExcelFilter. Please refer to the below UG and dashboard sample,

UG link:

https://help.syncfusion.com/windowsforms/gridgrouping/serialization#gridexcelfilter-serialization

Dashboard sample location:

<Installed Location>\Syncfusion\EssentialStudio\<Installed Version>\Windows\Grid.Grouping.Windows\Samples\Serialization\XML Serialization Demo\CS

Regards,

Sindhu