Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
16 views

Hi,

Could you, please help me find code examples for how to format filter dropdown items of decimal and datetime fields(columns) in telerik:RadGrid.
We need a comma separator for decimal fields.  Also, there is a chance of negative values, so in that case, we need to show its absolute value(within parentheses).
In the case of datetime fields, we need only the date without the time part (date format will be different for different agencies).

We changed the format of Invoice Date column in  ItemDataBound event as below.

dataItem["Date"].Text = rowItem.Date.ToString(AgencyDateFormat);

But it only changed the grid column values, not the filter dropdown.(image of mentioned issue is given below)

We changed the format of Amount column in  ItemDataBound event as below.

dataItem["Amt"].Text = string.Format("{0:0,0.00;(0.00)}", rowItem.Amt);

But it only changed the grid column values, not the filter dropdown.(image of mentioned issue is given below)

 

What we need is for the values shown in the filter will be in the same format of the corresponding column.

I solved this issue by using following code:

private void RadGrid_GridFilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)
        {
            string filterKey = e.Column.UniqueName;
            List<string> listOfItems = GetList(filterKey);

            foreach (var item in listOfItems)
            {
                if (e.Column.DataType == typeof(DateTime))
                {
                    DateTime datimeObj;
                    if (DateTime.TryParse(item, out datimeObj))
                    {
                        e.ListBox.Items.Add(new RadListBoxItem
                        {
                            Text = datimeObj.ToString(AgencyDateFormat),
                            Value = item
                        });
                        e.ListBox.DataTextFormatString = AgencyDateFormat;
                    }
                }
                else if (e.Column.DataType == typeof(decimal))
                {
                    decimal moneyObj;
                    if (decimal.TryParse(item, out moneyObj))
                    {
                        e.ListBox.Items.Add(new RadListBoxItem
                        {
                            Text = string.Format("{0:0,0.00;(0.00)}", moneyObj),
                            Value = item
                        });
                    }
                }
                else
                {
                    e.ListBox.DataSource = listOfItems;
                }
            }
            e.ListBox.DataBind();
        }

There is one more issue I'm facing. If the column contains a null or empty string, then I need to show them as "(Empty)" in the filter drop-down. How to do this?

We will appreciate your help.

Thanks

            
Vasko
Telerik team
 answered on 19 Feb 2024
1 answer
29 views

Hi

I have an application that had a telerik Rad Grid, with filtering enabled.

The application can be opened via another application, passing filters to the first 2 columns like below. However when passing the filters like this the rows are not reflecting what is in the filter. If I was to manually enter the value in the filter it will work.

 

I have this in my code for ItemDatabound

 protected void rg_CallDetails_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (!Page.IsPostBack)
            {
                if (!string.IsNullOrEmpty(department))
                {
                    rg_CallDetails.MasterTableView.FilterExpression = "([Department] " + "LIKE " + "\'%" + department + "%\' AND [CallNumber] " + "LIKE " + "\'" + callTypePre + "%\' ) ";
                    GridColumn column = rg_CallDetails.MasterTableView.GetColumnSafe("Department");
                    column.CurrentFilterFunction = GridKnownFunction.Contains;
                    column.CurrentFilterValue = department;


                    //rg_CallDetails.MasterTableView.FilterExpression = "([CallNumber] " + "LIKE " + "\'" + callTypePre + "%\') ";
                    GridColumn columnCallType = rg_CallDetails.MasterTableView.GetColumnSafe("CallNumber");
                    columnCallType.CurrentFilterFunction = GridKnownFunction.Contains;
                    columnCallType.CurrentFilterValue = callTypePre;

                    rg_CallDetails.MasterTableView.Rebind();

                }
            }

        }

But the application errors with stackoverflow exception error on the rebind.

I have tried rg_CallDetails.Rebind()

But also gives the same error.

Any advise please?

Thanks

 

                                       
Rakhee
Top achievements
Rank 1
Iron
Iron
 answered on 15 Nov 2023
0 answers
18 views

Hi 

I have radgrid for an application that has the filters set to show.

When the page first loads and grid is populated the filter works successfully, however if I do anything like click on another button so the page reloads for example, the filters stop working. So when I click on the filter button the drop down of options does not show anymore.

Any advise on why its behaving like this please?

Thanks

Rakhee

Rakhee
Top achievements
Rank 1
Iron
Iron
 updated question on 15 Nov 2023
0 answers
21 views

Hi, we found a problem after updating our project to our last available version witch is "Complimentary R1 2020 Version", we are on 2016.2.607.40, and after find a problem in radgrid and keyboard interaction we look at out download page and have the complimentary version, we try it and that problem solves, but in a recently added radfilter we discover that stop working as spectated.

 

We use RadFilterDropDown with radcomboboxes, which load on demand.

First, we see that load settings displays the saved info of combos in blank.

Second, we discover also that selecting a item from combo, not saving on settings and not showing on preview also

 

With 2016.2.607.40

With Trial version of 2023.3.1010 (we try it to see if problem solved on last version)

 

Attached isolated sample for reproduction
Maximiliano
Top achievements
Rank 1
 asked on 24 Oct 2023
1 answer
34 views

In the Excel-like Filtering example for ASP.NET AJAX, the RadGrid utilizes filtering by way of a HeaderContextFilterMenu.  Because of this distinction, the coding samples for setting/removing filters via javascript seem to be incompatible.

For example, with a standard RadGrid you could set a filter with the following javascript:

var masterTable = $find("<%= RadGrid1.ClientID %>").get_masterTableView();
masterTable.filter("OrderID", 10254, Telerik.Web.UI.GridFilterFunction.GreaterThan, true);

OR

var masterTable = $find("<%= RadGrid1.ClientID %>").get_masterTableView();
masterTable.filter("AccessLevel", "User", "EqualTo");
masterTable.sort("Name");

 

But since I'm using the "Excel-like Filtering" mode/style, when I try this same logic, it returns the following error after calling getElementByClassName:

Uncaught TypeError: d is null

 

My assumption is that there is a different set of steps/calls needed to set filtering when HeaderContextFilterMenu is involved.  Any ideas?

 

DefaultCS.aspx:

<%@ Page Language="c#" AutoEventWireup="false" CodeFile="DefaultCS.aspx.cs" Inherits="Telerik.GridExamplesCSharp.Functionality.Filtering.ExcelLikeFiltering.DefaultCS" %>
 
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" EnableAJAX="true">
     <div class="demo-container no-bg">
            <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" AllowFilteringByColumn="true" runat="server" FilterType="HeaderContext" EnableHeaderContextMenu="true" 
                EnableHeaderContextFilterMenu="true" AllowPaging="True" PagerStyle-AlwaysVisible="true" OnFilterCheckListItemsRequested="RadGrid1_FilterCheckListItemsRequested" DataSourceID="SqlDataSource1" AllowSorting="true" GroupingEnabled="true">
                <MasterTableView DataSourceID="SqlDataSource1" AutoGenerateColumns="False" DataKeyNames="CustomerID">
                    <Columns>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="ContactName" FilterControlAltText="Filter ContactName column" HeaderText="ContactName" SortExpression="ContactName" UniqueName="ContactName" AutoPostBackOnFilter="true" CurrentFilterFunction="StartsWith">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="ContactTitle" FilterControlAltText="Filter ContactTitle column" HeaderText="ContactTitle" SortExpression="ContactTitle" UniqueName="ContactTitle">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Address" FilterControlAltText="Filter Address column" HeaderText="Address" SortExpression="Address" UniqueName="Address">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="City" FilterControlAltText="Filter City column" HeaderText="City" SortExpression="City" UniqueName="City">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="Country" FilterControlAltText="Filter Country column" HeaderText="Country" SortExpression="Country" UniqueName="Country">
                        </telerik:GridBoundColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="SELECT * FROM [Customers]"></asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

 

DefaultCS.aspx.cs:

using Telerik.Web.UI;
using System;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
namespace Telerik.GridExamplesCSharp.Functionality.Filtering.ExcelLikeFiltering
{
    public partial class DefaultCS : System.Web.UI.Page
    {
        protected void RadGrid1_FilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)
        {
            string DataField = (e.Column as IGridDataColumn).GetActiveDataField();
 
            e.ListBox.DataSource = GetDataTable(DataField);
            e.ListBox.DataKeyField = DataField;
            e.ListBox.DataTextField = DataField;
            e.ListBox.DataValueField = DataField;
            e.ListBox.DataBind();
        }
 
        public DataTable GetDataTable(string field)
        {
            string query = string.Format("SELECT DISTINCT {0} FROM Customers", field);
 
            String ConnString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConnString);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(query, conn);
 
            DataTable myDataTable = new DataTable();
 
            conn.Open();
            try
            {
                adapter.Fill(myDataTable);
            }
            finally
            {
                conn.Close();
            }
 
            return myDataTable;
        }
    }
}

Attila Antal
Telerik team
 answered on 19 Oct 2023
1 answer
83 views

In the Excel-like Filtering example for ASP.NET AJAX, the RadGrid utilizes filtering by way of a HeaderContextFilterMenu.  In the example, there is a filter icon/button that you'd click on to open the column's context filter menu.  Once you apply the filter, the grid filters as you'd expect, but there is nothing to indicate which column is being filtered.  For that matter, if there are filters applied to multiple columns, there is no obvious way of knowing which columns are being filtered. 

Looking at the attached screenshot, I've filtered CONTACT TITLE column to only display records where the contact is an "Accounting Manager", but when you look at the results there is no visual clue that CONTACT TITLE has been filtered.

Using the provided sample code, how would you alter the code to have it toggle the column's filter icon/button to indicate which column(s) have an actively applied column filter? 

 

DefaultCS.aspx:

<%@ Page Language="c#" AutoEventWireup="false" CodeFile="DefaultCS.aspx.cs" Inherits="Telerik.GridExamplesCSharp.Functionality.Filtering.ExcelLikeFiltering.DefaultCS" %>
 
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" EnableAJAX="true">
     <div class="demo-container no-bg">
            <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" AllowFilteringByColumn="true" runat="server" FilterType="HeaderContext" EnableHeaderContextMenu="true" 
                EnableHeaderContextFilterMenu="true" AllowPaging="True" PagerStyle-AlwaysVisible="true" OnFilterCheckListItemsRequested="RadGrid1_FilterCheckListItemsRequested" DataSourceID="SqlDataSource1" AllowSorting="true" GroupingEnabled="true">
                <MasterTableView DataSourceID="SqlDataSource1" AutoGenerateColumns="False" DataKeyNames="CustomerID">
                    <Columns>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="ContactName" FilterControlAltText="Filter ContactName column" HeaderText="ContactName" SortExpression="ContactName" UniqueName="ContactName" AutoPostBackOnFilter="true" CurrentFilterFunction="StartsWith">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="ContactTitle" FilterControlAltText="Filter ContactTitle column" HeaderText="ContactTitle" SortExpression="ContactTitle" UniqueName="ContactTitle">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Address" FilterControlAltText="Filter Address column" HeaderText="Address" SortExpression="Address" UniqueName="Address">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="City" FilterControlAltText="Filter City column" HeaderText="City" SortExpression="City" UniqueName="City">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="Country" FilterControlAltText="Filter Country column" HeaderText="Country" SortExpression="Country" UniqueName="Country">
                        </telerik:GridBoundColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="SELECT * FROM [Customers]"></asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

 

DefaultCS.aspx.cs:

using Telerik.Web.UI;
using System;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
namespace Telerik.GridExamplesCSharp.Functionality.Filtering.ExcelLikeFiltering
{
    public partial class DefaultCS : System.Web.UI.Page
    {
        protected void RadGrid1_FilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)
        {
            string DataField = (e.Column as IGridDataColumn).GetActiveDataField();
 
            e.ListBox.DataSource = GetDataTable(DataField);
            e.ListBox.DataKeyField = DataField;
            e.ListBox.DataTextField = DataField;
            e.ListBox.DataValueField = DataField;
            e.ListBox.DataBind();
        }
 
        public DataTable GetDataTable(string field)
        {
            string query = string.Format("SELECT DISTINCT {0} FROM Customers", field);
 
            String ConnString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConnString);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(query, conn);
 
            DataTable myDataTable = new DataTable();
 
            conn.Open();
            try
            {
                adapter.Fill(myDataTable);
            }
            finally
            {
                conn.Close();
            }
 
            return myDataTable;
        }
    }
}



 

Rumen
Telerik team
 answered on 06 Oct 2023
1 answer
50 views

Hello

i'm stuck with a simple example.

I have a RadGrid with multiple column avec ExcelFilter activated.

When in a column, you have data like 'test AND test' the Filter got no FilterExpression when you select this particular line in  the filter with a tickbox.

If you use the Filter fonction normally (Contain) it work.

 

Here is a simple exemple.

Default.aspx :


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
        </Scripts>
    </telerik:RadScriptManager>
    <div>
        <telerik:RadGrid ID="GridFile" runat="server"         
            OnNeedDataSource="ContextGrid_NeedDataSource"
            AllowSorting="true"
            AllowFilteringByColumn="True"
            FilterType="HeaderContext"
            EnableHeaderContextMenu="true" 
            EnableHeaderContextFilterMenu="true"
            OnFilterCheckListItemsRequested="RadGrid1_FilterCheckListItemsRequested"  
            FilterMenu-EnableRoundedCorners="false"
            >
             <MasterTableView AutoGenerateColumns="false" TableLayout="Auto"> 
                <Columns>
                    <telerik:GridBoundColumn UniqueName="Creation" DataField="Creation" HeaderText="Creation"   FilterCheckListEnableLoadOnDemand="true"/>
                    <telerik:GridBoundColumn UniqueName="Name" DataField="Name" HeaderText="Name" FilterCheckListEnableLoadOnDemand="true"/>
                 </Columns>
            </MasterTableView>
        </telerik:RadGrid>
    </div>
    </form>
</body>
</html>


And Defaults.aspx.cs 


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


public partial class Default : System.Web.UI.Page 
{
    
    protected void ContextGrid_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
    {
        DataTable table = new DataTable();

        GridFile.DataSource = getTable();
    }


    protected void RadGrid1_FilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)
    {
        string DataField = (e.Column as IGridDataColumn).GetActiveDataField();
        DataTable table = getTable();

        table.DefaultView.Sort = DataField + " asc";

        e.ListBox.DataSource = table.DefaultView.ToTable(true, DataField);
        e.ListBox.DataKeyField = DataField;
        e.ListBox.DataTextField = DataField;
        e.ListBox.DataValueField = DataField;
        e.ListBox.DataBind();
    }

    protected DataTable getTable()
    {
        DataTable table = new DataTable();
        table.Columns.Add("Creation", typeof(string));
        table.Columns.Add("Name", typeof(string));

        int i = 0;
        for (i=0; i < 10; i++)
        {

            table.Rows.Add(
                "Name " + i,
                i + " The AND a test"
                ) ;
        }
        return table;
    }

}

 

Selection and Error in the 2 captures.

Works with OR also.

Any Clues ?

Thinks it's the same error like the quote.

 

Thanks a lot

Benjamin

 

Doncho
Telerik team
 answered on 12 Sep 2023
0 answers
53 views

Please help me to search the error ,

the radgrid table disappear after filtering the search, 
I tried to find any solution a lot but i did not find a solution for this problem

 


aspx code :
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
    </telerik:RadAjaxLoadingPanel>


 <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" >
                                        <AjaxSettings>
                                            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                                                <UpdatedControls>
                                                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                                                    <telerik:AjaxUpdatedControl ControlID="RadGrid2" />
                                                    <telerik:AjaxUpdatedControl ControlID="RadGrid3" />
                                                    <telerik:AjaxUpdatedControl ControlID="RadGrid4" />
                                                </UpdatedControls>
                                            </telerik:AjaxSetting>
                                        </AjaxSettings>
                            </telerik:RadAjaxManager>
                                    

                            <telerik:RadGrid EnableAriaSupport="true" ID="RadGrid1" runat="server" AllowPaging="true" AllowSorting="true" PageSize="20" ShowStatusBar="true"
                                 CellSpacing="0" GridLines="None" ClientSettings-EnablePostBackOnRowClick="false" AllowFilteringByColumn="True">
                                <MasterTableView AutoGenerateColumns="false" TableLayout="Fixed" DataKeyNames="REQ_ID" >
                                    <HeaderStyle HorizontalAlign="Center" ForeColor="#009900" Font-Names="Arial" Font-Bold="true" Font-Size="Medium" Height="50px"/>
                                    <Columns>
                                        <telerik:GridMaskedColumn DataField="REQ_ID" HeaderText="رقم الطلب" UniqueName="Req_num_r1" Visible="true" AllowFiltering="false">
                                        </telerik:GridMaskedColumn>
                                        <telerik:GridBoundColumn DataField="EMP_NAME" HeaderText="اسم الموظف/ طالب الخدمة" AllowFiltering="true"  UniqueName="EMP_NAME_ra" Visible="true" HeaderStyle-Width="15%">
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn DataField="NAME" HeaderText="الخدمة المقدمة" UniqueName="Problem_Name_r1" Visible="true" ColumnGroupName="GeneralInformation">
                                            <FilterTemplate>
                                                <telerik:RadComboBox RenderMode="Lightweight" ID="Problem_NameCombo1" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Problem_Name_r1").CurrentFilterValue %>'
                                                    runat="server" OnClientSelectedIndexChanged="Problem_NameComboIndexChanged1" AutoPostBack="true">
                                                    <Items>
                                                        <telerik:RadComboBoxItem Text="All" Value="" />
                                                        <telerik:RadComboBoxItem Text="مشكلة في الطباعة" Value="مشكلة في الطباعة" />
                                                        <telerik:RadComboBoxItem Text="سكانر" Value="سكانر" />
                                                        <telerik:RadComboBoxItem Text="مشكلة في الشبكة" Value="مشكلة في الشبكة" />
                                                        <telerik:RadComboBoxItem Text="البريد الحكومي" Value="البريد الحكومي" />
                                                        <telerik:RadComboBoxItem Text="الارشيف" Value="الارشيف" />
                                                        <telerik:RadComboBoxItem Text="موارد" Value="موارد" />
                                                        <telerik:RadComboBoxItem Text="الانترنت" Value="الانترنت" />
                                                        <telerik:RadComboBoxItem Text="جهاز الحاسوب" Value="جهاز الحاسوب" />
                                                        <telerik:RadComboBoxItem Text="حزمة الاوفيس" Value="حزمة الاوفيس" />
                                                        <telerik:RadComboBoxItem Text="موقع الديوان" Value="موقع الديوان" />
                                                    </Items>
                                                </telerik:RadComboBox>
                                                <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
                                                    <script type="text/javascript">
                                                        function Problem_NameComboIndexChanged1(sender, args) {
                                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                                            tableView.filter("Problem_Name_r1", args.get_item().get_value(), "EqualTo");
                                                        }
                                                    </script>
                                                </telerik:RadScriptBlock>
                                            </FilterTemplate>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridDateTimeColumn DataField="CREATE_DATE" ItemStyle-CssClass="sm-visible" HeaderText="وقت انشاء الطلب" DataFormatString="{0:g}" UniqueName="Create_date_r1">
                                        </telerik:GridDateTimeColumn>
                                        <telerik:GridBoundColumn DataField="provider" HeaderText="مقدم الخدمة" UniqueName="provider_r1" HeaderStyle-Width="20%">
                                        </telerik:GridBoundColumn>
                                        <telerik:GridDateTimeColumn DataField="END_DATE" HeaderText="وقت تنفيذ الطلب" DataFormatString="{0:g}" UniqueName="END_DATE_r1" Visible="true">
                                        </telerik:GridDateTimeColumn>
                                        <telerik:GridMaskedColumn DataField="Responsiveness" HeaderText="سرعة الانجاز" UniqueName="Responsiveness_r1" AllowFiltering="false">
                                        </telerik:GridMaskedColumn>


                                    </Columns>

                                    <NestedViewTemplate>

                                        <div class="Table" style="background-color: #a7d1e2">

                                            <div class="TableRow col-12">
                                                <div class="TableCell p-3" style="inline-size: 100%; overflow-wrap: break-word;"><b class="text-danger">تفاصيل المشكلة : </b><%# Eval("DESCRIPTION") %> </div>
                                                <div class="TableCell p-2" style="inline-size: 100%; overflow-wrap: break-word;"><b class="text-danger">ملاحظات مقدم الخدمة : </b><%# Eval("NOTE") %> </div>
                                                <div class="TableCell p-2">
                                                    <b class="text-danger">تقييم الخدمة  : 
                                                          <div class="progress-bar" role="progressbar" style="width:100px ;" aria-valuenow='<%# Convert.ToDouble(Eval("FEEDBACK_RATING"))*20 %>' aria-valuemin="0" aria-valuemax="100"><%# Convert.ToDouble(Eval("FEEDBACK_RATING"))*20 %> %</div>

                                                    </b>

                                                </div>
                                            </div>

                                        </div>

                                    </NestedViewTemplate>
                                </MasterTableView>
                                <ClientSettings>
                                    <DataBinding SelectMethod="GetDataAndCount">
                                    </DataBinding>
                                </ClientSettings>
                            </telerik:RadGrid>


Rafi
Top achievements
Rank 1
 asked on 23 May 2023
0 answers
50 views

Hello.

I am having issues with filter on any RadGrid on my site.

WHenever I try to filter using "Less than or equal" or "Greater than or equal" it does nothing. But it throws the following JavaScript error whenever I click the filter button:

ManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: No property or field 'rEqualTo' exists in type 'DataRowView'

It seems to be a built-in file used by Telerik for filtering.

Any help would be appreciated

Many thanks.

Christian
Top achievements
Rank 1
Iron
 asked on 16 May 2023
2 answers
301 views

How to un-highlight filtered yellow records. I used Ctrl+F to search keywords, those matching records were highlighed in yellow. Now I want to remove the highlighted(yellow) recorded. 

 

Jared
Top achievements
Rank 1
Iron
 answered on 15 Mar 2023
Narrow your results
Selected tags
Tags
+? more
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?