Filter by wildcard in gridview

[Nitin]

Hi Telerik team,

 I want to filter columns by specifying wildcards. Is there any way to specify the wildcard as bellow:
 columnFilter.FieldFilter.Filter1.Value=cell.value;

I have another query regarding the performance in gridview. I had binded the grid to a datatable with 100 columns X 10000 rows. When i apply programmatic filtering or sorting, the grid lags. I had enabled the virtualization in the grid, but it didnt had any improvement. 

Is there any other way to filter the columns in the grid other than specified in your help . i had used IColumnFilterDescriptor , but its slow. Is there any other way to filter .

Following are the system environment:
WPF version: 4.5
OS: windows 7
exact version of the Telerik product: 2013 Q2 SP1
preferred programming language :  C#

Regards
Nitin

[Dimitrina]

Hello Nitin,

I am not sure that I understand your question regarding filtering the columns specifying wildcards:columnFilter.FieldFilter.Filter1.Value=cell.value; 
Would you please explain more details on that?

The way we suggest to filter RadGridView is as explained in our online documentation. There are also many topics under section "Filtering" explaining in details how the filtering is performed. 

Please note that for filtering, sorting and grouping the columns we use LINQ queries built at run-time.
For example in your solution, when you want to filter on the Name property, the statement will be similar to:

ObservableCollection<ViewModelBase> collection = viewModel.GetItems();
var result = collection.Where(viewModelBase => viewModelBase.Name == "Something");

Regards,
Didie
Telerik