[Solved] Filter Template Error

[Najid Hanif]

I am trying to create my own custom filter like in the example outlined here:

http://www.telerik.com/help/aspnet-ajax/grid-custom-option-for-filtering.html

The only difference is that my column is a template column, What do i need to do? Thanks

Error on line: RadGrid1.MasterTableView.Rebind();
Telerik.Web.UI.ParseException was unhandled by user code
  Message=Expression expected
  Source=Telerik.Web.UI

ASPX

<telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn column"
    HeaderText="Status" UniqueName="Status">

<FilterTemplate>
  <telerik:RadComboBox runat="server" ID="FilterCombo" DataSourceID="StatusList"
                       DataValueField="StatusID" DataTextField="Status" AutoPostBack="true"
                       OnSelectedIndexChanged="FilterCombo_SelectedIndexChanged">
  </telerik:RadComboBox>
</FilterTemplate>

    <EditItemTemplate>
        <telerik:RadComboBox ID="RadComboBox_StatusList" runat="server"
            AutoPostBack="true" DataSourceID="StatusList" DataTextField="Status"
            DataValueField="StatusID"
            OnSelectedIndexChanged="RadComboBox_StatusList_SelectedIndexChanged"
            SelectedValue='<%#Bind("StatusID") %>'>
        </telerik:RadComboBox>
    </EditItemTemplate>
    <ItemTemplate>
         <%#DataBinder.Eval(Container.DataItem, "Status")%>
    </ItemTemplate>
    <ItemStyle Width="240px" />
</telerik:GridTemplateColumn>

C#

protected void FilterCombo_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
    string filterExpression;
    filterExpression = "([Status] = '" + e.Value + "')";
    RadGrid1.MasterTableView.FilterExpression = filterExpression;
    RadGrid1.MasterTableView.Rebind();
}

[Pavlina]

Hello Najid Hanif,

Please try setting EnableLinqExpressions property of the RadGrid control to false and check whether this eliminates the exception.

Best wishes,
Pavlina
the Telerik team

[Najid Hanif]

This does eliminate the exception but the filter does not do anything though. I select the item from the dropdown, and it reverts back to what was selected before and nothning is filtered.

[Princy]

Hello Najid,

Make sure that you have set DataField property for the GridTemplateColumn.

aspx:

<telerik:GridTemplateColumn DataField="StatusID" FilterControlAltText="Filter TemplateColumn column"
    HeaderText="Status" UniqueName="Status">
  . . .
</telerik:GridTemplateColumn>

Thanks,
Princy.

[Najid Hanif]

Thanks for the quick response, that did not change any behavior though.

[Princy]

Hello Najid,

Make a double check your code with the following demo which implements the same.
Grid / Filter Templates.

Thanks,
Princy.

[Najid Hanif]

That does not really help much as that is client side with java script.

I am trying to use this example, at the bottom:

http://www.telerik.com/help/aspnet-ajax/grid-filtertemplate.html

Does that example not work?
Thanks

[Najid Hanif]

I figured it out. The SQL Col needed to be changed to the ID col


 filterExpression = "([StatusID] = '" + e.Value + "')";