Hi,
I'm trying to implement grid filtering like it works in SPGridView. I made a custom column which was bounded to the same table as RadGrid.
I want to apply sequential filtering on columns (if user selects filter value from first column, then all other columns should limit results based on this criteria). User can filter by multiple columns in grid.
How can I achieve this?
Marko
I'm trying to implement grid filtering like it works in SPGridView. I made a custom column which was bounded to the same table as RadGrid.
I want to apply sequential filtering on columns (if user selects filter value from first column, then all other columns should limit results based on this criteria). User can filter by multiple columns in grid.
How can I achieve this?
Marko
3 Answers, 1 is accepted
0
Hello Marko,
I suppose by SPGridView filtering you have in mind the filtering of RadPivotGrid. Do keep in mind that it is not a trivial scenario and our development team is tackling it at the moment so that it be released as an out of the box feature for the next Q.
Regards,
Tsvetoslav
Telerik
I suppose by SPGridView filtering you have in mind the filtering of RadPivotGrid. Do keep in mind that it is not a trivial scenario and our development team is tackling it at the moment so that it be released as an out of the box feature for the next Q.
Regards,
Tsvetoslav
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
0
Marko
Top achievements
Rank 1
Rank 1
answered on 26 Jun 2013, 10:55 AM
Hi,
No, I didn't have had RadPivotGrid in mind. My requirement is to do it using RadGrid.
Approach is similar to this approach:
http://www.telerik.com/help/aspnet-ajax/grid-applying-default-filter-on-initial-load.html
But in this case, it will get all distinct values for dropdowns, no matter if user already selected something from list.
So, how can I include filtering criteria in dropdown list source, based on supplied example?
Best regards,
Marko
No, I didn't have had RadPivotGrid in mind. My requirement is to do it using RadGrid.
Approach is similar to this approach:
http://www.telerik.com/help/aspnet-ajax/grid-applying-default-filter-on-initial-load.html
But in this case, it will get all distinct values for dropdowns, no matter if user already selected something from list.
So, how can I include filtering criteria in dropdown list source, based on supplied example?
Best regards,
Marko
0
Hi Marko,
The principle for accomplishing this is simple, the coding - requires more work. So, all in all RadComboBox is bound to whatever data you have passed to it. Therefore, if the grid is filtered by some criteria, then take this criteria and apply it to the combo's data source. For example, if the grid is filtered by ProductID > 5, then when binding the combo pass to it the same criteria. If it is bound using a SqlDataSource, for instance, change the select command of the data source control to include a where clause having ProductID > 5.
Regards,
Tsvetoslav
Telerik
The principle for accomplishing this is simple, the coding - requires more work. So, all in all RadComboBox is bound to whatever data you have passed to it. Therefore, if the grid is filtered by some criteria, then take this criteria and apply it to the combo's data source. For example, if the grid is filtered by ProductID > 5, then when binding the combo pass to it the same criteria. If it is bound using a SqlDataSource, for instance, change the select command of the data source control to include a where clause having ProductID > 5.
Regards,
Tsvetoslav
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.