Filtering not working

[Steve]

Hi,

I'm new with Telerik.  I took a demo and modified it for my own use, as I was going along, the filters were working, now they are not.  I have custom and standard filters.  They do nothing but generate an error.  When running I get an error in VS2013, when I try to access one of the filters:

Error: Sys.WebForms.PageRequestManagerServerErrorException: ORA-00936: missing expression

 Obviously this is an oracle error.

 None of my filters are working and they all return a similar error

 Can someone provide some guidance on what to check for?

Thanks

​

[Jayesh Goyani]

Hello,

 It would be nice if you will provide your code.

Thanks,

Jayesh Goyani

[Steve]

Ok,

Here's my aspx:

 

<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    Style: <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" /><br />
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdateInitiatorPanelsOnly="true">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
        <br />
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />
    <div class="my-container no-bg">
        <telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True"
            AllowSorting="True" AllowPaging="True" PageSize="10" runat="server" AutoGenerateColumns="False"
            OnPreRender="RadGrid1_PreRender" ShowStatusBar="True" EnableLinqExpressions="False" GroupPanelPosition="Top">
            <MasterTableView ShowFooter="True" TableLayout="Fixed">
                <Columns>
                    <telerik:GridBoundColumn HeaderStyle-Width="100px" UniqueName="APPLICATION_EVENT_ID" DataField="APPLICATION_EVENT_ID" HeaderText="Event ID" DataType="System.Decimal" FilterControlAltText="Filter APPLICATION_EVENT_ID column" SortExpression="APPLICATION_EVENT_ID">
                        <FilterTemplate>
                            Clear filters
                        <asp:ImageButton ID="btnShowAll" runat="server" ImageUrl="Img/filterCancel.gif" AlternateText="Clr Filters"
                            ToolTip="Clear Filters" OnClick="btnShowAll_Click" Style="vertical-align: middle" />
                        </FilterTemplate>

                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn FilterControlWidth="20px" HeaderStyle-Width="60px" UniqueName="SEVERITY" DataField="SEVERITY" HeaderText="Severity">


                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn HeaderStyle-Width="90px"  UniqueName="PLATFORM" DataField="PLATFORM" HeaderText="Platform" FilterControlAltText="Filter PLATFORM column" SortExpression="PLATFORM">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxPlatform" DataSourceID="SqlDataSource3" DataTextField="Platform"
                                DataValueField="Platform" Width="80px" Height="80px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("PLATFORM").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="PlatIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">
                                <script type="text/javascript">
                                    function PlatIndexChanged(sender, args) {
                                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("Platform", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>

                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="MESSAGE_GROUP" HeaderStyle-Width="70px"  HeaderText="Message Group" SortExpression="MESSAGE_GROUP" UniqueName="MESSAGE_GROUP">
                    <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxMG" DataSourceID="SqlDataSource4" DataTextField="MESSAGE_GROUP"
                                DataValueField="MESSAGE_GROUP" Width="55px" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("MESSAGE_GROUP").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="MGIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">
                                <script type="text/javascript">
                                    function MGIndexChanged(sender, args) {
                                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("MESSAGE_GROUP", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ALARM_LEVEL" HeaderStyle-Width="60px" FilterControlAltText="Filter ALARM_LEVEL column" FilterControlWidth="20px" HeaderText="Alarm Level" SortExpression="ALARM_LEVEL" UniqueName="ALARM_LEVEL">
                    </telerik:GridBoundColumn>
                    <telerik:GridDateTimeColumn HeaderStyle-Width="135px" DataField="OCCURANCE_TIME" DataType="System.DateTime" HeaderText="Occurence Time" PickerType="DatePicker" EnableTimeIndependentFiltering="true"
                            DataFormatString="{0:MM/dd/yyyy hh:mm:ss}" FilterControlWidth="90px" SortExpression="OCCURANCE_TIME" UniqueName="OCCURANCE_TIME">
                    </telerik:GridDateTimeColumn>
                    <telerik:GridBoundColumn DataField="APPLICATION" HeaderStyle-Width="150px" FilterControlAltText="Filter APPLICATION column" HeaderText="Application" SortExpression="APPLICATION" UniqueName="APPLICATION">
                    <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxApp" DataSourceID="SqlDataSource5" DataTextField="APPLICATION"
                                DataValueField="APPLICATION" Width="140px" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("APPLICATION").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="AppIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock4" runat="server">
                                <script type="text/javascript">
                                    function AppIndexChanged(sender, args) {
                                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("APPLICATION", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="APP_VERSION" AllowFiltering="false" HeaderText="App Version" HeaderStyle-Width="65px" UniqueName="APP_VERSION">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="REPORTED_BY" FilterControlAltText="Filter REPORTED_BY column" HeaderText="Reported" HeaderStyle-Width="100px" FilterControlWidth="65px" SortExpression="REPORTED_BY" UniqueName="REPORTED_BY">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="JOBNUM" FilterControlAltText="Filter JOBNUM column" HeaderText="Job Number" SortExpression="JOBNUM" UniqueName="JOBNUM" HeaderStyle-Width="70px" FilterControlWidth="35px">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn HeaderStyle-Width="400px" Resizable="true" DataField="MESSAGE" AllowFiltering="false" AllowSorting="false" HeaderText="Message" UniqueName="MESSAGE">
                    </telerik:GridBoundColumn>


                    <telerik:GridDateTimeColumn HeaderStyle-Width="135px" DataField="ACKNOWLEDGE_DATE" DataType="System.DateTime" HeaderText="Acknowledge Date" PickerType="DatePicker" EnableTimeIndependentFiltering="true"
                            DataFormatString="{0:MM/dd/yyyy hh:mm:ss}" FilterControlWidth="90px" SortExpression="ACKNOWLEDGE_DATE" UniqueName="ACKNOWLEDGE_DATE">
                    </telerik:GridDateTimeColumn>
                    <telerik:GridBoundColumn DataField="ACKNOWLEDGED_BY" FilterControlAltText="Filter ACKNOWLEDGED_BY column" HeaderStyle-Width="120px" HeaderText="Acknowledged By" SortExpression="ACKNOWLEDGED_BY" UniqueName="ACKNOWLEDGED_BY">
                    </telerik:GridBoundColumn>


                    <telerik:GridCheckBoxColumn DataField="Bool" DataType="System.Boolean" DefaultInsertValue=""
                        HeaderText="Acknowledge" UniqueName="Bool">
                    </telerik:GridCheckBoxColumn>


                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

        <br />
        <telerik:RadToolTip ID="RadToolTip1" runat="server" OffsetY="3" Position="TopCenter"
        ShowCallout="false" Height="20px" ShowEvent="fromcode" />
    <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT * FROM PF_APPLICATION_EVENT WHERE ACKNOWLEDGED_BY is NULL order by SEVERITY"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT Severity FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT Platform FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT MESSAGE_GROUP FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource5" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT APPLICATION FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
</div>

and here's my aspx.cs:

using Telerik.Web.UI;
using System;
using System.Web.UI;
using System.Data;

namespace Telerik.GridExamplesCSharp.Functionality.Filtering.FilterTemplates
{
    public partial class DefaultCS : System.Web.UI.Page
    {
        protected void ImportedFilter_ItemDataBound(object sender, RadComboBoxItemEventArgs e)
        {
            DataRowView rowView = (DataRowView)e.Item.DataItem;
            if (rowView["Bool"] is DBNull)
            {
                e.Item.Text = "No";
                e.Item.Value = "0";
            }
            else if ((bool)rowView["Bool"])
            {
                e.Item.Text = "Yes";
                e.Item.Value = "1";
            }
        }



        protected void RadGrid1_PreRender(object sender, System.EventArgs e)
        {
            if (RadGrid1.MasterTableView.FilterExpression != string.Empty)
            {
                RefreshCombos();
            }
        }
        protected void RefreshCombos()
        {
            SqlDataSource2.SelectCommand = SqlDataSource2.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();
            SqlDataSource3.SelectCommand = SqlDataSource3.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();
            SqlDataSource4.SelectCommand = SqlDataSource4.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();
            SqlDataSource5.SelectCommand = SqlDataSource4.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();

            RadGrid1.MasterTableView.Rebind();
        }
        /*        protected DateTime? SetShippedDate(GridItem item)
                {
                    if (item.OwnerTableView.GetColumn("ShippedDate").CurrentFilterValue == string.Empty)
                    {
                        return new DateTime?();
                    }
                    else
                    {
                        return DateTime.Parse(item.OwnerTableView.GetColumn("ShippedDate").CurrentFilterValue);
                    }
                }
        */
        protected DateTime? startDate
        {
            set
            {
                ViewState["strD"] = value;
            }
            get
            {
                if (ViewState["strD"] != null)
                    return (DateTime)ViewState["strD"];
                else
                    return new DateTime(1996, 7, 4);
            }
        }
        protected DateTime? endDate
        {
            set
            {
                ViewState["endD"] = value;
            }
            get
            {
                if (ViewState["endD"] != null)
                    return (DateTime)ViewState["endD"];
                else
                    return new DateTime(1998, 5, 6);
            }
        }

        protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        { }

        protected void btnShowAll_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            RadGrid1.MasterTableView.FilterExpression = string.Empty;

            foreach (GridColumn column in RadGrid1.MasterTableView.RenderColumns)
            {
                if (column is GridBoundColumn)
                {
                    GridBoundColumn boundColumn = column as GridBoundColumn;
                    boundColumn.CurrentFilterValue = string.Empty;
                }
            }
            this.startDate = null;
            this.endDate = null;

            RadGrid1.MasterTableView.Rebind();

        }

[Steve]

OK, I'm sure it is something silly, but I don't see it.  Thanks for looking!

 here's my aspx:

<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    Style: <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" /><br />
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdateInitiatorPanelsOnly="true">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
        <br />
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />
    <div class="my-container no-bg">
        <telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True"
            AllowSorting="True" AllowPaging="True" PageSize="10" runat="server" AutoGenerateColumns="False"
            OnPreRender="RadGrid1_PreRender" ShowStatusBar="True" EnableLinqExpressions="False" GroupPanelPosition="Top">
            <MasterTableView ShowFooter="True" TableLayout="Fixed">
                <Columns>
                    <telerik:GridBoundColumn HeaderStyle-Width="100px" UniqueName="APPLICATION_EVENT_ID" DataField="APPLICATION_EVENT_ID" HeaderText="Event ID" DataType="System.Decimal" FilterControlAltText="Filter APPLICATION_EVENT_ID column" SortExpression="APPLICATION_EVENT_ID">
                        <FilterTemplate>
                            Clear filters
                        <asp:ImageButton ID="btnShowAll" runat="server" ImageUrl="Img/filterCancel.gif" AlternateText="Clr Filters"
                            ToolTip="Clear Filters" OnClick="btnShowAll_Click" Style="vertical-align: middle" />
                        </FilterTemplate>

                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn FilterControlWidth="20px" HeaderStyle-Width="60px" UniqueName="SEVERITY" DataField="SEVERITY" HeaderText="Severity">


                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn HeaderStyle-Width="90px"  UniqueName="PLATFORM" DataField="PLATFORM" HeaderText="Platform" FilterControlAltText="Filter PLATFORM column" SortExpression="PLATFORM">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxPlatform" DataSourceID="SqlDataSource3" DataTextField="Platform"
                                DataValueField="Platform" Width="80px" Height="80px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("PLATFORM").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="PlatIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">
                                <script type="text/javascript">
                                    function PlatIndexChanged(sender, args) {
                                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("Platform", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>

                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="MESSAGE_GROUP" HeaderStyle-Width="70px"  HeaderText="Message Group" SortExpression="MESSAGE_GROUP" UniqueName="MESSAGE_GROUP">
                    <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxMG" DataSourceID="SqlDataSource4" DataTextField="MESSAGE_GROUP"
                                DataValueField="MESSAGE_GROUP" Width="55px" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("MESSAGE_GROUP").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="MGIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">
                                <script type="text/javascript">
                                    function MGIndexChanged(sender, args) {
                                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("MESSAGE_GROUP", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ALARM_LEVEL" HeaderStyle-Width="60px" FilterControlAltText="Filter ALARM_LEVEL column" FilterControlWidth="20px" HeaderText="Alarm Level" SortExpression="ALARM_LEVEL" UniqueName="ALARM_LEVEL">
                    </telerik:GridBoundColumn>
                    <telerik:GridDateTimeColumn HeaderStyle-Width="135px" DataField="OCCURANCE_TIME" DataType="System.DateTime" HeaderText="Occurence Time" PickerType="DatePicker" EnableTimeIndependentFiltering="true"
                            DataFormatString="{0:MM/dd/yyyy hh:mm:ss}" FilterControlWidth="90px" SortExpression="OCCURANCE_TIME" UniqueName="OCCURANCE_TIME">
                    </telerik:GridDateTimeColumn>
                    <telerik:GridBoundColumn DataField="APPLICATION" HeaderStyle-Width="150px" FilterControlAltText="Filter APPLICATION column" HeaderText="Application" SortExpression="APPLICATION" UniqueName="APPLICATION">
                    <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxApp" DataSourceID="SqlDataSource5" DataTextField="APPLICATION"
                                DataValueField="APPLICATION" Width="140px" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("APPLICATION").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="AppIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock4" runat="server">
                                <script type="text/javascript">
                                    function AppIndexChanged(sender, args) {
                                        var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("APPLICATION", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="APP_VERSION" AllowFiltering="false" HeaderText="App Version" HeaderStyle-Width="65px" UniqueName="APP_VERSION">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="REPORTED_BY" FilterControlAltText="Filter REPORTED_BY column" HeaderText="Reported" HeaderStyle-Width="100px" FilterControlWidth="65px" SortExpression="REPORTED_BY" UniqueName="REPORTED_BY">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="JOBNUM" FilterControlAltText="Filter JOBNUM column" HeaderText="Job Number" SortExpression="JOBNUM" UniqueName="JOBNUM" HeaderStyle-Width="70px" FilterControlWidth="35px">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn HeaderStyle-Width="400px" Resizable="true" DataField="MESSAGE" AllowFiltering="false" AllowSorting="false" HeaderText="Message" UniqueName="MESSAGE">
                    </telerik:GridBoundColumn>


                    <telerik:GridDateTimeColumn HeaderStyle-Width="135px" DataField="ACKNOWLEDGE_DATE" DataType="System.DateTime" HeaderText="Acknowledge Date" PickerType="DatePicker" EnableTimeIndependentFiltering="true"
                            DataFormatString="{0:MM/dd/yyyy hh:mm:ss}" FilterControlWidth="90px" SortExpression="ACKNOWLEDGE_DATE" UniqueName="ACKNOWLEDGE_DATE">
                    </telerik:GridDateTimeColumn>
                    <telerik:GridBoundColumn DataField="ACKNOWLEDGED_BY" FilterControlAltText="Filter ACKNOWLEDGED_BY column" HeaderStyle-Width="120px" HeaderText="Acknowledged By" SortExpression="ACKNOWLEDGED_BY" UniqueName="ACKNOWLEDGED_BY">
                    </telerik:GridBoundColumn>


                    <telerik:GridCheckBoxColumn DataField="Bool" DataType="System.Boolean" DefaultInsertValue=""
                        HeaderText="Acknowledge" UniqueName="Bool">
                    </telerik:GridCheckBoxColumn>


                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

        <br />
        <telerik:RadToolTip ID="RadToolTip1" runat="server" OffsetY="3" Position="TopCenter"
        ShowCallout="false" Height="20px" ShowEvent="fromcode" />
    <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT * FROM PF_APPLICATION_EVENT WHERE ACKNOWLEDGED_BY is NULL order by SEVERITY"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT Severity FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT Platform FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT MESSAGE_GROUP FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource5" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT DISTINCT APPLICATION FROM PF_APPLICATION_EVENT"
        runat="server"></asp:SqlDataSource>
</div>

 

and here's my aspx.cs:

using Telerik.Web.UI;
using System;
using System.Web.UI;
using System.Data;

namespace Telerik.GridExamplesCSharp.Functionality.Filtering.FilterTemplates
{
    public partial class DefaultCS : System.Web.UI.Page
    {
        protected void ImportedFilter_ItemDataBound(object sender, RadComboBoxItemEventArgs e)
        {
            DataRowView rowView = (DataRowView)e.Item.DataItem;
            if (rowView["Bool"] is DBNull)
            {
                e.Item.Text = "No";
                e.Item.Value = "0";
            }
            else if ((bool)rowView["Bool"])
            {
                e.Item.Text = "Yes";
                e.Item.Value = "1";
            }
        }



        protected void RadGrid1_PreRender(object sender, System.EventArgs e)
        {
            if (RadGrid1.MasterTableView.FilterExpression != string.Empty)
            {
                RefreshCombos();
            }
        }
        protected void RefreshCombos()
        {
            SqlDataSource2.SelectCommand = SqlDataSource2.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();
            SqlDataSource3.SelectCommand = SqlDataSource3.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();
            SqlDataSource4.SelectCommand = SqlDataSource4.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();
            SqlDataSource5.SelectCommand = SqlDataSource4.SelectCommand + " WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString();

            RadGrid1.MasterTableView.Rebind();
        }
        /*        protected DateTime? SetShippedDate(GridItem item)
                {
                    if (item.OwnerTableView.GetColumn("ShippedDate").CurrentFilterValue == string.Empty)
                    {
                        return new DateTime?();
                    }
                    else
                    {
                        return DateTime.Parse(item.OwnerTableView.GetColumn("ShippedDate").CurrentFilterValue);
                    }
                }
        */
        protected DateTime? startDate
        {
            set
            {
                ViewState["strD"] = value;
            }
            get
            {
                if (ViewState["strD"] != null)
                    return (DateTime)ViewState["strD"];
                else
                    return new DateTime(1996, 7, 4);
            }
        }
        protected DateTime? endDate
        {
            set
            {
                ViewState["endD"] = value;
            }
            get
            {
                if (ViewState["endD"] != null)
                    return (DateTime)ViewState["endD"];
                else
                    return new DateTime(1998, 5, 6);
            }
        }

        protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        { }

        protected void btnShowAll_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            RadGrid1.MasterTableView.FilterExpression = string.Empty;

            foreach (GridColumn column in RadGrid1.MasterTableView.RenderColumns)
            {
                if (column is GridBoundColumn)
                {
                    GridBoundColumn boundColumn = column as GridBoundColumn;
                    boundColumn.CurrentFilterValue = string.Empty;
                }
            }
            this.startDate = null;
            this.endDate = null;

            RadGrid1.MasterTableView.Rebind();

        }

[Pavlina]

Hello,

More information on the error and possible solution is provided in the link below:
http://www.orasite.com/errores/ORA/ORA-00936

If the information is not useful for you, isolate the error in a sample runnable project and send it to us so we can 
debug it locally.

Regards,
Pavlina
Telerik