This is a migrated thread and some comments may be shown as answers.

Filtering with FilterTemplate does not work.

14 Answers 496 Views

Grid

This is a migrated thread and some comments may be shown as answers.

jfkrueger asked on 06 Mar 2009, 06:03 PM

I have followed the example here to the letter:

http://www.telerik.com/help/aspnet-ajax/radgrid-filter-template.html

I have used the code-behind method since I am not using an EntityDataSource. However, it just doesn't work. After selecting a different item from the combobox it goes through the code to set the filter but then the combobox just gets reset to it's original value and nothing is filtered.

Here is my grid:

    
            <telerik:RadGrid ID="RadGridEmployeeTransactions" runat="server"   
        
                AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True"   
        
                AutoGenerateColumns="False" GridLines="None" ShowGroupPanel="False" Width="620px" 
        
                EnableLinqExpressions="false">  
        
                <HeaderContextMenu> 
        
                    <CollapseAnimation Duration="200" Type="OutQuint" /> 
        
                </HeaderContextMenu> 
        
                <PagerSTyle AlwaysVisible="true" Mode="NextPrevNumericAndAdvanced" /> 
        
                <MasterTableView> 
        
                    <Columns> 
        
                        <telerik:GridBoundColumn DataField="TransactionID" Groupable="False"   
        
                            HeaderText="ID" ReadOnly="True" SortExpression="TransactionID"   
        
                            UniqueName="TransactionID" 
        
                            FilterControlWidth="50px">  
        
                            <HeaderStyle HorizontalAlign="Center" Width="70px" /> 
        
                            <ItemStyle HorizontalAlign="Center" Width="70px" />                                          
        
                        </telerik:gridboundcolumn> 
        
                        <telerik:GridBoundColumn DataField="DateSubmitted" Groupable="True"   
        
                            HeaderText="Date Submitted" ReadOnly="True" SortExpression="DateSubmitted"   
        
                            UniqueName="DateSubmitted" GroupByExpression="DateSubmitted" > 
        
                            <HeaderStyle HorizontalAlign="Left" Width="130px" /> 
        
                            <ItemStyle HorizontalAlign="Left" Width="130px" /> 
        
                            <FilterTemplate> 
        
                                <telerik:RadComboBox ID="RadComboboxDateSubmittedFilter" 
        
                                    runat="server" AutoPostBack="true" OnSelectedIndexChanged="RadComboboxDateSubmittedFilter_SelectedIndexChanged">  
        
                                    <Items> 
        
                                        <telerik:RadComboBoxItem Value="2009" Text="2009" /> 
        
                                        <telerik:RadComboBoxItem Value="2008" Text="2008" /> 
        
                                    </Items> 
        
                                </telerik:RadComboBox> 
        
                            </FilterTemplate> 
        
                        </telerik:gridboundcolumn> 
        
                        <telerik:GridBoundColumn DataField="Tooltip" Groupable="True"   
        
                            HeaderText="Transaction Type" ReadOnly="True" SortExpression="Tooltip"   
        
                            UniqueName="Tooltip" GroupByExpression="Tooltip"   
        
                            FilterControlWidth="200px">  
        
                            <HeaderStyle HorizontalAlign="Left" Width="250px" /> 
        
                            <ItemStyle HorizontalAlign="Left" Width="250px" /> 
        
                        </telerik:gridboundcolumn> 
        
                        <telerik:GridBoundColumn DataField="Status" Groupable="True"   
        
                            HeaderText="Transaction Type" ReadOnly="True" SortExpression="Status"   
        
                            UniqueName="Status" GroupByExpression="Status"   
        
                            FilterControlWidth="100px">  
        
                            <HeaderStyle HorizontalAlign="Left" Width="150px" /> 
        
                            <ItemStyle HorizontalAlign="Left" Width="150px" /> 
        
                        </telerik:gridboundcolumn> 
        
                    </Columns> 
        
                </MasterTableView> 
        
                <ClientSettings AllowDragToGroup="True">  
        
                </ClientSettings> 
        
                <FilterMenu> 
        
                    <CollapseAnimation Duration="200" Type="OutQuint" /> 
        
                </FilterMenu> 
        
            </telerik:RadGrid>

And here is the event handler:

    
                Public Sub RadComboboxDateSubmittedFilter_SelectedIndexChanged(ByVal sender As Object, ByVal e As RadComboBoxSelectedIndexChangedEventArgs)  
        
                    Dim lBeginDate As String = "1/1/" & e.Value + " 12:00:00 AM" 
        
                    Dim lEndDate As String = "12/31/" & e.Value  + " 11:59:59 PM" 
        
                    Dim lFilterExpression As String = String.Format(CultureInfo.CurrentCulture, "([DateSubmitted] BETWEEN '{0}' AND '{1}'", lBeginDate, lEndDate)  
        
                    RadGridEmployeeTransactions.MasterTableView.FilterExpression = lFilterExpression   
        
                    RadGridEmployeeTransactions.MasterTableView.Rebind()  
        
                End Sub

What gives? It seems like the filtering is a great feature but once you start getting into a complicated design (multiple master pages, user controls etc. all of the functionality is broken. I wouldn't even be trying to use the FilterTemplate if the normal filters worked on this page but they don't. No filteroptions are even displayed upon clicking the filter image.

Filtering on this grid is needed and I do not want to have to re-write my query so that I can pass in all of the filter criteria and then do all the filtering manually, that kind of defeats the purpose of using your controls.

Any help to get this resolved is greatly appreciated.

Thanks!

14 Answers, 1 is accepted

answered on 06 Mar 2009, 07:00 PM

And more info....

Ok, so with the <FilterTemplate> the fields that are strings KIND OF work. Meaning that they do filter the grid but all of the filter fields are still being reset to their original values so the filter that the user selected is gone once the grid is filtered and all of the comboboxes go back to the "Not Filtered" value.

So this means there are two problems here:

Filtering on Date fields or Numeric fields does not work at all.
Anytime any filter is selected or updated, all of the filter controls values are set back to the original values and what the user has selected is no longer selected.

I feel like i'm getting closer but could really use some help getting these issues ironed out.

Thanks!

answered on 07 Mar 2009, 08:20 AM

Hello Joe,

I am sorry to hear that you are having a hard time implementing filtering with different types of controls for your RadGrid for ASP.NET AJAX.

Generally speaking, the filter controls for the grid columns will vary based on their data type as shown in this online demo of the product:

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/filtering/defaultcs.aspx

Additionally, you have the option to implement your own custom column with filter control of your choice as demonstrates here:

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filteringtemplatecolumns/defaultcs.aspx

One more option you will have with the Q1 2009 release of the suite (expected in mid March) is declarative filter template option. It is also available in the Q3 2008 SP2 version (2008.3.1314) of the grid and presented in this example from the Q1 2009 Beta release of the product:

http://demos.telerik.com/aspnet-ajax-beta/grid/examples/programming/filtertemplate/defaultcs.aspx

Finally, concerning the issue with the empty filters:
Can you please verify that you are using advanced binding for the grid intercepting its NeedDataSource event or using a data source control as in the demos linked above?

Kind regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 07 Mar 2009, 10:38 PM

Hello, thanks for the response but I think maybe I didn't articulate my problem very well. In any case, I have figured out how to manually persist the filter values selected by the user after they update a filter and how to filter by more than one field so I have at least worked these issues out. Just wish I didn't have to manually do this stuff and that the control would handle it for me (I think it is supposed to but it just does not work for me when it is buried inside a WebUserControl and two layers of MasterPages.

I am a little confused though because you say that the filter values should be automatically persisted but in other posts the Telerik people say that a call to Rebind() will clear the filter values out and the user has to figure out a way to persist them. I have to call Rebind() because I am using <FilterTemplates> and am binding in the NeedsDataSource event. The reason I had to go this direction in the first place is because the normal filtering just didn't work in my situation. I would click on the little filter icon and no menu would pop up and nothing would happen. Oh well. I've pretty much got it figured out doing everything manually except for actually having the database re-queried upon the filtering of a specific date field (rather than just filtering the existing data) but that is in another post.

The filter on the date field is still not working though and I have no idea why. That is why I am attempting to just re-query the database instead of trying to use the filter, but I can't get that to work either so it is in another post.

answered on 09 Mar 2009, 07:56 AM

Hello Joe,

Indeed if you invoke explicitly the Rebind() method of the grid to refresh its state, the filter values in the textboxes might be lost and you may need to retain them explicitly. Since this is quite common scenario, I spoke with our developers on this subject and you may be happy to know that for the Q1 2009 release of RadControls for ASP.NET AJAX we will add a second grid to this online demo:

http://demos.telerik.com/aspnet-ajax-beta/grid/examples/programming/filtertemplate/defaultcs.aspx

which will illustrate how to perform date range, date and slider range filter and persist the filter values when the grid is rebound. Please stand by for the next release of the suite, expected within a week and let us know whether the updated version of the demo is helpful to you.

Kind regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.