ClientSideBinding with default filter

[Kristijan]

Dear Experts,

I am using RadGrid to implement a business application showing some tabular data which should be filtered according to the responsible user(owner).

In order to maximize the user experience I used two additional features 

• client side binding and
• combo box filter template to allow the owner the selection

The problem is that I am not able to apply default filter on initial load with client side binding. I suppose this should be possible by properly initialize the Grid’s server state that reflects on the client as filterExpressions array.

I tried the following approaches but none seems to be the right one:

•  Applying default filter on initial load or Operating with the FilterExpression of Telerik RadGrid manually, but seems to have impact only on the server side loading functionality.
• Setting the “List<GridFilterExpression>” but I found no suitable attribute on the Grid to be set.

I am using (DNN - RadAjax Version: 2011.2.712.35

Has anyone experience with this approach?

Any hint will be highly appreciated.

Thank you, 
Kristijan

[Andrey]

Hello,

Applying filter expressions on Initial load is also supported scenario, however you need to make few adjustments to the code:

• You need to add HiddenField control and based on the condition of the Page.IsPostBack property to set its value for example to "true" or "false" on the server Page_Load event.
• Then on client pageLoad event to check what is the hidden field value and based on this value  to apply the filter expression to the desired tableview.
• Additionally in the RadCombox client SelectedIndexChanged event for the item with text "All" you need to clear the filterExpressions collection by calling the clearFilter function.

The aforementioned steps describe pretty much everything needed to get working filter template with initial filtering and client-side binding, however I have created a sample project to illustrate this approach.

Give it a try and check whether if it is working as expected.

Kind regards,
Andrey
the Telerik team

[Kristijan]

Hi Andrey,

Thank you for your answer. Although I got not a complete answer to my problem (I need to initialize the filter with changeable date – you used a constant), it helps me to understand the required approach.

Now I understand there is no possibility to preset the filter on the server side, by setting some grid attributes, but only through the help of the hidden fields and some JavaScript on the client side. So now I am going to set the Id of the current user in another hidden field and use it as an argument in the filter function (see below).

Thank you again,

Kristijan

function pageLoad(sender, args) {
    var hdnField = $get("<%=hdnField.ClientID %>");
    var radGrid = $find("<%=RadGrid1.ClientID %>");
    var hdnUserId = $get("<%=hdnUserId.ClientID %>");
    if (hdnField.value === 'true') {
        radGrid.get_masterTableView().filter("Name", hdnUserId, Telerik.Web.UI.GridFilterFunction.EqualTo, true);
    }
}

[Andrey]

Hello,

Yes, you are on the right track with this approach. You just need to take care of changing the value of the hdnUserId control on the server and I think you will not have problems with this approach.

All the best,
Andrey
the Telerik team