Hello
Is there a way to filter the data grid at load of the page on the current day
I am alreday ussing the Range select handler an it works fine the moment i change the date's
but the list is to big and only want to show at load the data of the current date
public DateTime? StartValue { get; set; } = DateTime.Now;
public DateTime? EndValue { get; set; } = DateTime.Now;
public Query Qry = new Query();
//public void OnChange(RangeEventArgs Args)
public void RangeSelectHandler(RangePickerEventArgs<DateTime?> Args)
{
if (Args.StartDate != null)
{
var Col1Pre = new WhereFilter();
var predicate = new List<WhereFilter>();
predicate.Add(new WhereFilter() { Condition = "or", Field = "POLineOrderDate", value = Args.StartDate, Operator = "greaterthanorequal" });
predicate.Add(new WhereFilter() { Condition = "or", Field = "POLineOrderDate", value = Args.EndDate, Operator = "lessthanorequal" });
Col1Pre = WhereFilter.And(predicate);
Qry = new Query().Where(Col1Pre); // to filter the Grid
}
else
{
Qry = new Query();
}
}
