date range defaults

[Robert]

I have implemented the date range filter template with two raddatepicker controls to filter records between a startdate and an enddate.
My table contains records from 2001 til 2012. How can I effectively setup defaults so that initially only records from say 2011-2012 are shown ? I have set the startdate control to 01-01-2011 but of course the date range values are only added to the filterexpression when a user selects a different date value.

Regards,
Robert

[Eyup]

Hello Robert,

Thank you for contacting us.

You could apply filtering on initial page load as shown below:

Copy Code

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridColumn col = RadGrid1.MasterTableView.GetColumnSafe("OrderDate") as GridColumn;
GridFilteringItem filterItem = RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)[0] as GridFilteringItem;
col.CurrentFilterValue = DateTime.Now.Date.ToString();
filterItem.FireCommandEvent("Filter", new Pair("EqualTo", "OrderDate"));
if (RadGrid1.Items.Count == 0)
{
RadGrid1.MasterTableView.FilterExpression = string.Empty;
RadGrid1.MasterTableView.Rebind();
}
}
}

An alternative approach would be the following:
  mark-up:

Copy Code

<telerik:RadGrid ... EnableLinqExpressions="false" OnPreRender="RadGrid1_PreRender">

  C#:

Copy Code

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RadGrid1.MasterTableView.FilterExpression = "[OrderDate]='" + DateTime.Now.Date.ToString() + "'";
}
}

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
if (!IsPostBack && RadGrid1.Items.Count == 0)
{
RadGrid1.MasterTableView.FilterExpression = string.Empty;
RadGrid1.MasterTableView.Rebind();
}
}

  
Please note that in spite of "EqualTo", you will need to use "Between" filter function according to your specific scenario. Please refer to the topic below for additional details on filter expressions:
 Operating with the FilterExpression of Telerik RadGrid Manually

Additionally, you could check out the following demo which demonstrates how to preserve the text in a Filter Template with two date pickers:
 Grid / Filter Templates

I hope this will prove helpful.

Greetings,
Eyup
the Telerik team

[Robert]

**updated: never mind: was a globalization issue**

Thanks, I will try your suggestion.
In the meantime I have a different -strange- problem.
I customized the filtertemplate example and included the daterange filter, which works fine.
That is: if I compile and run the project inside VS, using the buildin localhost webserver.
Now when I publish the precompiled website to our local intranet, the daterange filter does not filter anything, all records are displayed, and the loading panel forever keeps on showing the rotating cursor...... Any suggestion where to search for this problem ?

Kind regards,
Robert

[Robert]

Eyup,

Your suggestion works, but only on the initial pageload.
As soon as we select a value from one of the dropdownlists of other filtercolumns the default filtercondition for our daterange filter is ignored.

Kind regards,
Robert

Code:

Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load

 

If Not IsPostBack Then

 RadGrid1.MasterTableView.FilterExpression = "(([T$QDAT] >= '01/01/2011') AND ([T$QDAT] <= '31/12/2015'))"

End If

End Sub

 

Protected Sub RadGrid1_PreRender(ByVal source As Object, ByVal e As System.EventArgs) Handles RadGrid1.PreRender

If (Not IsPostBack And RadGrid1.Items.Count = 0) Then 
   RadGrid1.MasterTableView.FilterExpression = String.Empty

   RadGrid1.MasterTableView.Rebind()

 

   RefreshCombos()

 

End If

 

 

 

 

 

 

End Sub

[Eyup]

Hi Robert,

In order to preserve the filtered value, please try the following:

  protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        RadGrid1.MasterTableView.FilterExpression = "([ShipCountry] LIKE \'%Germany%\') ";
        GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("ShipCountry");
        column.CurrentFilterFunction = GridKnownFunction.Contains;
        column.CurrentFilterValue = "Germany";
        RadGrid1.MasterTableView.Rebind();
    }
}

As demonstrated in the demo below:
 Applying Default Filter on Initial Load

That should solve the issue.

Kind regards,
Eyup
the Telerik team