Hello,
I've some questions and wishes concerning filtering. I'm using RIA services and I've defined the domain datasource in xaml and have set the page size.
When opening the filter dialog I can select just the values of the current page. This is a functionality I normally never need, because I choose always a page size, that the grid fits on the screen and then this selection is useless for me.
I would be happy if I could have solutions for the items listed below.
1. First of all I would like to consider the whole amount of data and not only the ones within the current page. If it takes some time I want to show the user a small Isbusy control.
2. To avoid that too much data are read from the server I would like to have the option to specify that I just want to take the most relevant item like that "select top 10 country,COUNT(*) from [Northwind].[dbo].[Customers] group by country" and an additional button the user can use to load all items. In this case the heavy loading is just neccessary when the use explicitly requests all the data.
3. I would like to make the "select" area invisible, so that just the area "Show rows with value that ... And ..." is shown where I can manually enter a filter values.
If I have e.g. 10.000 customers it doesn't make sense for my user to show a list with all the single customers, because he will always use the option to filter manually. That means the filter dialog could appear immediately because no dynamic construction of the select area is necessary.
4. Another request I have is dynamically reconstructing the filter dialog. Let's say I have selected certain values in the select area. If the filter area is closed and reopen for adjusting the filter criteria, only the checked items are shown. That means if I want to check an additional item I have to click the "clear filter" button and then all the items are shown in the grid again, but the filter dialog is not reconstructed and I have to close and reopen it and make the whole filtering again.
I have to admit that I'm a newbie with the telerik grid, so there might be some solutions for my request, so if there are please give my a hint how to solve these problems. The most important item for me would be item 3 and of course this adjustment is necessary on a per column base, so I can defined if I want to have a full featured filter dialog with the select area or without.
Thanks
Uwe
1 Answer, 1 is accepted
Straight onto your questions.
1. With the 2009 Q3 Release we will provide an event called DistinctValuesLoading. With the help of this event you will be able to replace the default logic with your own and provide the distinct values that you desire.
2. We have plans to provide a property of each column which will allow you to replace the default FilteringDropDown with your own home-made control. Having your own filtering drop-down will provide unlimited opportunities. You can design it to match your needs.
3. Same as two. When you are able to plug-in your custom FilteringDropDown it could be designed in any way.
4. I believe that this was a bug which was recently fixed. If you upgrade to our Latest Internal Build version it should work as expected. Please, let us know if that is not the case.
Please, let us know if you have any other questions.
Sincerely yours,
Ross
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.