I’m trying to filter on client side. I’ve looked at many posts and tutorial but I still can’t get it to work.

Hi after taking the limitations of setting loadonce to true into consideration (which is needed for client-side filtering to work), I decided to do server-side filtering. Below is my server side code for filtering.

public JsonResult DisplayCustDetails(string sidx, string sord, int page, int rows, bool _search, string filters)

{
var serializer = new JavaScriptSerializer();
//var context = new HaackOverflowEntities();
var CustExcelData = TempData[“ExcelData”] as List < CustDataResponse > ;
TempData.Keep(“ExcelData”);
JqGridFilters f = (!_search || string.IsNullOrEmpty(filters)) ? null : serializer.Deserialize < JqGridFilters > (filters);
if (CustExcelData != null) {
var CustDetails = CustExcelData.Where(a => a.InUse == true);
sord = (sord == null) ? “” : sord;
int pageIndex = Convert.ToInt32(page) – 1;
int pageSize = rows;

var totalRecords = CustDetails.Count();
var totalPages = (int) Math.Ceiling((float) totalRecords / (float) rows);

if (f != null && f.rules != null && f.rules.Count > 0) {
foreach(JqGridFilters.Rule rule in f.rules) {
switch (rule.field) {
.
.
.
break;
case “Invoice_Date”:
if (rule.op.ToString() == “cn”) {
CustDetails = CustDetails.Where(t => t.Invoice_Date.ToString().ToLower().Contains(rule.data.ToLower()));
} else if (rule.op.ToString() == “eq”) {
CustDetails = CustDetails.Where(t => t.Invoice_Date.ToString().ToLower().Equals(rule.data.ToLower()));
} else if (rule.op.ToString() == “lt”) {
CustDetails = CustDetails.Where(t => t.Invoice_Date < Convert.ToDateTime(rule.data));
} else if (rule.op.ToString() == “le”) {
CustDetails = CustDetails.Where(t => t.Invoice_Date <= Convert.ToDateTime(rule.data));
} else if (rule.op.ToString() == “gt”) {
CustDetails = CustDetails.Where(t => t.Invoice_Date > Convert.ToDateTime(rule.data));
} else if (rule.op.ToString() == “ge”) {
CustDetails = CustDetails.Where(t => t.Invoice_Date >= Convert.ToDateTime(rule.data));
}
break;
.
.
.
}
}
}

switch (sidx) {
.
.
.
break;
case “Invoice_Date”:
if (sord.ToUpper() == “DESC”) {
CustDetails = CustDetails.OrderByDescending(t => t.Invoice_Date);
CustDetails = CustDetails.Skip(pageIndex * pageSize).Take(pageSize);
} else {
CustDetails = CustDetails.OrderBy(t => t.Invoice_Date);
CustDetails = CustDetails.Skip(pageIndex * pageSize).Take(pageSize);
}
break;

.
.
.
}

var jsnData = new {
total = totalPages,
page,
records = totalRecords,
rows = CustDetails
};

return Json(jsnData, JsonRequestBehavior.AllowGet);
}
} catch (Exception ex) {

}
return null;
}

Also you mentioned that you need to know my setup. What do you mean by setup?