Default filtering settings

[STEVEN]

Hi,

I have a few  questions with regards to filtering in RadGrid.
1)
Is there anyway for me to set these filtering settings by default so that I dun have to type this for every columns?
  <telerik:GridBoundColumn DataField="FieldName" HeaderText="1st WS" HeaderStyle-Width="20px"
                    HeaderTooltip="Something" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

2) When I use CurrentFilterFunction="Contains", how I specify case insensitive matching?

3) Is there anyway to apply the filter without a flicker on the page due to AutoPostBackOnFilter="true" ?


Thanks

[Jayesh Goyani]

hi,

1.

as per my knowledge in Radgrid you can not achieve this directly(by skin).
write this function in your global/common file and called this function "SetCurrentFilterforGrid" in your page.

//// your web page code
........
SetCurrentFilterforGrid(RadGrid1);
........


//// commmon / global class
public static void SetCurrentFilterforGrid(ref RadGrid RadGrid1)
{
    foreach (GridColumn column in RadGrid1.Columns)
    {
        column.CurrentFilterFunction = GridKnownFunction.Contains;
    }

}

2. for insensitive matching :  <GroupingSettings CaseSensitive="false" />

3. Please explain your problem because i am not able to understand this.

let me know if any concern.

Thanks,
Jayesh Goyani

[STEVEN]

Thank you for the quick response.

1)
This is what I have done in the Code Behind

public partial class MyGrid : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SetCurrentFilterforGrid(ref RadGrid1);
    }
 
    public static void SetCurrentFilterforGrid(ref RadGrid RadGrid1)
    {
        foreach (GridColumn column in RadGrid1.Columns)
        {
            column.CurrentFilterFunction = GridKnownFunction.Contains;
            column.AutoPostBackOnFilter = true;
        }
 
    }
}

But it doesn't work as expected. I would like the Grid to auto-apply the 'Contain' filter when the user's mouse exits the filter box.

2) This works, insensitive matching :  <GroupingSettings CaseSensitive="false" />

3) This is related to (1). How can I avoid a full postback, and only refresh the grid with the filtered data?

[Jayesh Goyani]

Hi,

for stop the full post back use below code.

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

please elaborate the first case in detail.(Means you want to set some text in filter box and apply contain filter fuction correct ??)

Thanks,
Jayesh Goyani

[STEVEN]

Hi,

For the first case, you are right.
In addition, I will like the Grid to auto-apply the CONTAIN filter when the mouse leaves the filterbox, so that the user dun have to choose the FILTER function AND dun have to click the filtering button.


I have another question, what is the purpose of EnableAlternatingItems here? 

 <ClientSettings EnableAlternatingItems="true"

Thanks

[Princy]

Hello Steven,

The EnableAlternatingItems is for avoiding the Zebra line appearance for the skins which is having different styles for the item and alternating item. For that you need to set this property to false and see the difference.

Hope it helps.

Thanks,
Princy.

[STEVEN]

Hi,
My 1st question is unanswered. How do I go about this?
I will like the Grid to auto-apply the CONTAIN filter when the mouse leaves the filterbox, so that the user dun have to choose the FILTER function AND dun have to click the filtering button.

[Princy]

Hello Steven,

You can try the same approach in the following help documentation.
Search on Key Press/Button Click.

Thanks,
Princy.

[STEVEN]

I am able to get this to work if I explicitly configure the CurrentFilterFunction & AutoPostBackOnFilter for every column in the aspx.
But unable to work when I set it in the code behind. I am looking for a way to configure all our RadGrid behavior with minimum coding/configuration, preferably from a centralized location.

This is the aspx file

    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <%--Needed for JavaScript IntelliSense in VS2010--%>
            <%--For VS2008 replace RadScriptManager with ScriptManager--%>
            <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>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />
 
    <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
 
        <telerik:RadGrid ID="RadGrid1" runat="server" 
            GridLines="None" 
            AllowSorting="True"
            PageSize="10" 
            AllowPaging="True" PagerStyle-Position="Bottom" PagerStyle-Mode="NextPrevNumericAndAdvanced"
            DataSourceID="DataSource1" 
            AllowFilteringByColumn="True"> 
 
            <GroupingSettings CaseSensitive="false" />
 
        <ClientSettings>
            <Scrolling AllowScroll="true" 
                       FrozenColumnsCount="3"
                       UseStaticHeaders="true" 
                       EnableVirtualScrollPaging="true" />
        </ClientSettings>
 
            <MasterTableView Width="100%" AllowMultiColumnSorting="true" AllowNaturalSort="true">
            </MasterTableView>
        </telerik:RadGrid>
        <telerik:RadWindowManager ID="RadWindowManager1" runat="server">
        </telerik:RadWindowManager>
    </telerik:RadAjaxPanel>
    <asp:SqlDataSource SelectCommand="SELECT Customers.* FROM Customers" ConnectionString="<%$ ConnectionStrings:TelerikVSXConnectionString1 %>"
        ProviderName="System.Data.SqlClient" ID="DataSource1" runat="server"></asp:SqlDataSource>
    </form>

THis is the code behind

public partial class MyGrid : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SetCurrentFilterforGrid(this.RadGrid1);
    }
 
    public static void SetCurrentFilterforGrid(RadGrid RadGrid1)
    {
        foreach (GridColumn column in RadGrid1.Columns)
        {
            column.CurrentFilterFunction = GridKnownFunction.Contains;
            column.AutoPostBackOnFilter = true;
        }
 
    }
}

[Marin]

Hi Steven,

 From the code sample that you posted it looks like you are using autogenerated columns for the RadGrid. If this is the case you should iterate over the AutoGeneratedColumns collection instead and set the desired properties in a later event after which you should rebind the grid:

protected void Page_PreRenderComplete(object sender, EventArgs e)
        {
            foreach (GridColumn column in RadGrid1.MasterTableView.AutoGeneratedColumns)
            {
                column.CurrentFilterFunction = GridKnownFunction.EqualTo;
                column.AutoPostBackOnFilter = true;
            }
            RadGrid1.Rebind();
        }

Kind regards,
Marin
the Telerik team

[STEVEN]

Thanks, I manage to get this working.

2 things to modify to get it working:
1) Use the RadGrid1.MasterTableView.AutoGeneratedColumns 2) Use Page_PreRenderComplete instead of Page_Load. My question is why Page_PreRenderComplete instead of Page_Load?

[Jayesh Goyani]

hello,

please read this page's life-cycle Life-Cycle Events.

Thanks,
Jayesh Goyani