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

Filtering not working

4 Answers 21 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Steve
Top achievements
Rank 1
Steve asked on 11 Aug 2015, 05:52 PM

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

‚Äč

4 Answers, 1 is accepted

Sort by
0
Jayesh Goyani
Top achievements
Rank 2
answered on 12 Aug 2015, 05:18 PM

Hello,

 It would be nice if you will provide your code.

Thanks,

Jayesh Goyani

0
Steve
Top achievements
Rank 1
answered on 13 Aug 2015, 06:50 PM

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();
 
        }
0
Steve
Top achievements
Rank 1
answered on 13 Aug 2015, 06:55 PM

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();
 
        }

0
Pavlina
Telerik team
answered on 14 Aug 2015, 09:33 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Grid
Asked by
Steve
Top achievements
Rank 1
Answers by
Jayesh Goyani
Top achievements
Rank 2
Steve
Top achievements
Rank 1
Pavlina
Telerik team
Share this question
or