Filtering not working

5 posts, 0 answers
  1. Steve
    Steve avatar
    3 posts
    Member since:
    Jul 2015

    Posted 11 Aug 2015 Link to this post

    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

  2. Jayesh Goyani
    Jayesh Goyani avatar
    2732 posts
    Member since:
    May 2010

    Posted 12 Aug 2015 in reply to Steve Link to this post

    Hello,

     It would be nice if you will provide your code.

    Thanks,

    Jayesh Goyani

  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Steve
    Steve avatar
    3 posts
    Member since:
    Jul 2015

    Posted 13 Aug 2015 Link to this post

    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();
     
            }
  5. Steve
    Steve avatar
    3 posts
    Member since:
    Jul 2015

    Posted 13 Aug 2015 Link to this post

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

  6. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 14 Aug 2015 Link to this post

    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
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017