We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
|
<When refreshing the Grid>
var dataManager =ej.DataManager({ url: "/Home/DataSource", adaptor: "UrlAdaptor"});
$("#Grid").ejGrid({
dataSource: dataManager,
allowResizing: true,
allowPaging: true,
allowSorting: true,
allowReordering: true,
allowSelection: false,
enablePersistence: false,
allowTextWrap: true,
allowFiltering:true,
pageSettings: { pageSize: 10, pageCount: 10 },
toolbarSettings: { showToolbar: true, toolbarItems: [ej.Grid.ToolBarItems.ExcelExport] },
toolbarClick:"toolbarClick",
}); //Now single request will send to server side
<Or>
//Refresh the datasource using setmodel
$("#Grid").ejGrid("option", { dataSource: ej.DataManager({ url: "/LoanApplicationQuery/List", adaptor: new ej.UrlAdaptor() }) })
|
|
$(function () {
var dataManager =ej.DataManager({ url: "/Home/DataSource", adaptor: "UrlAdaptor"});
var field = "OrderID";
var operator = "equal";
var value = 10249;
$("#Grid").ejGrid({
dataSource: dataManager,
. . .
filterSettings: { filterType: "menu", filteredColumns: [{ field: field, operator: operator, value: value }] },
. . .
columns: [
. . .
]
});
}); |
|
<style>
.e-grid .e-headercell .e-filtericon {
display:none;//Hide the filter icons from Grid
}
</style> |
|
var gridObj = $("#Grid").ejGrid("instance");
. . .
//Pass operators & value as array
gridObj.filterColumn([{
field: "OrderDate",
operator: [ej.FilterOperators.greaterThanOrEqual, ej.FilterOperators.lessThanOrEqual],
value: [startDate, endDate],
predicate: ["and","and"]
}]);
}
|
Hi Venkatesh,
Hi Venkatesh,
Thanks for your inputs regarding multiple filter options. I work with Joel and we hit a couple more issues related to filtering and exporting:
- seems each item passed into the gridObj.filterColumn() generates individual calls to the datamanager url, appending additional filter each time. In the sample snippet here: http://jsplayground.syncfusion.com/ed20prfi a total of 4 server calls were made to the datamanager url. Once during the grid initialization, and 3 times more apparently because I passed 3 filter column items. Is there a way to prevent this duplicate server calls?
- Related to previous scenario, we wanted the grid to always load with an initial filter applied. Seems we cannot do this during initialization - $("#Grid").ejGrid(...). If there's no way for that, can we then suppress the grid from making that remote call to the datamanager url during initialization (i.e. ejGrid() call), so we can just have a single server call when the gridObj.filterColumn() gets executed?
- When doing export via ej.Grid.exportAll() call. Is there a way to hook a javascript callback when the exported file gets downloaded?
Thanks in advance for your help!Chris Joson
