Excel Like Filtering Advance Filter's filter type drop down

[Kevin Kuan]

Hi,

Can I know is there anyway i can populate the excel like filtering drop down with only the filter type I want.

Taking the example of Text Filters, there are Equals, Not Equals, BeginsWith, Contains, EndsWith, Empty, Not Empty, Null , Not Null.

How do i remove the empty, not empty, null and not null from the dropdown list?

Best Regard,

Kevin

[Saravanan C]

Hi Kevin,

 

Thank you for contacting Syncfusion Support.

 

You can remove the null and not null filter types by setting the property AllowBlankFilter=”False” in grid column. Please refer the code sample in below:

 

Code Snippet[XAML]:

<syncfusion:SfDataGrid.Columns>

    <syncfusion:GridTextColumn MappingName="OrderID"

                               AllowBlankFilters="False"/>

</syncfusion:SfDataGrid.Columns>

 

And also if you want to remove the empty and not empty filter types from advanced text filtering, then you can achieve this by editing the control template for AdvancedFilterControl and changing the items source of the PART_MenuComboBox1 and PART_MenuComboBox2 with your items source. We have created the sample based on your requirement, please find the sample in the attachments.

 

Please let us know the provided solution helps you.

 

Thanks,

Saravanan C

Attachment: ExcelLikeFilteringDemo_81c49ac1.zip