How do I both filter AND search a specific column?

[Mark]

I visited https://help.syncfusion.com/wpf/datagrid/search for the purpose of doing two things:

1. Filter results

2. Column-specific search

I've implemented them both but the problem is that the filtering works regardless of the column specified.

-----------------------

Say I have this table:

Name	Quantity	Brand
Viper Steel	1	Patriot
Vengeance LPX	2	Corsair
Trident Z	3	G.Skill

Now I want to:

1. Filter results that has "ri"

2. Search only under the column "Name"

What happens after running "ProductDataGrid.SearchHelper.Search("ri");" is:

1. 2nd row (Vengeance LPX) gets filtered out - this is intentional and running fine

2. It'll still show the 1st row with Viper Steel because the string "ri" exists within the brand Pat"ri"ot. But what I really wanted to do was to only look for "ri" among the Name column, if it doesn't exist there then filter it out, it doesn't matter whether there's a "ri" string from other columns.

[Shobika Palani]

Hi Mark,   

  

Thank you for contacting Syncfusion Support.   

  

We have KB for searching and filtering in specific column alone which satisfies your requirement. Please refer the below KB link.  

  

KB Link:   

https://www.syncfusion.com/kb/9297/how-to-apply-search-and-filter-for-one-column-in-sfdatagrid    

  

Also, please refer the below sample.  

Sample Link:   

https://www.syncfusion.com/downloads/support/forum/148895/ze/SearchFilteringDemo-1840832613    

  

Please let us know, if you need any further other assistance from us.   

  

Regards,
Shobika  

[Mark]

Thank you so much for the reply it worked

[Mohanram Anbukkarasu]

Hi Mark, 

Thanks for the update. 

We are glad to know that the provided solution worked at your end. Please let us know if you have any further queries on this. We are happy to help you. 

Regards, 

Mohanram A