Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
0
Remote Filtering
posted

Hi,

I just updated from version 2014.2 to 2023.2 and noticed that remote filtering is not working anymore.
I'm using MVC and this is the code that is working with 2014.2

Html.Infragistics().Grid<Index.CustomerViewModel>()
.ID("grid")
.PrimaryKey("Id")
.AutoGenerateColumns(false)
.Columns(c =>
{
c.For(m => m.Name).HeaderText("Name").Width("20%");
c.For(m => m.TailNumbers).HeaderText("Tail Numbers").Width("20%");
c.For(m => m.CompanyName).HeaderText("Company").Width("15%");
c.For(m => m.Status).HeaderText("Customer Status").Width("15%");
c.For(m => m.City).HeaderText("City").Width("12%");
c.For(m => m.State).HeaderText("State").Width("5%");
c.For(m => m.Active).HeaderText(StringResources.String_Active).Format("checkbox").Width("5%");
c.For(m => m.Id).HeaderText("").Template("<div class=\"gridButton\"><a href=\"" + Url.Action("Edit") + "/${Id}\" onclick='saveLastPage()' class=\"btn btn-info\"><span class=\"glyphicon glyphicon-edit\"></span>" + StringResources.String_Edit + "</a></div>").Width("8%");
})
.Features(f =>
{
f.Filtering().Type(OpType.Remote).Mode(FilterMode.Simple).FilterSummaryAlwaysVisible(false).FilterDropDownItemIcons(true).ColumnSettings(s =>
{
s.ColumnSetting().ColumnKey("Name").AllowFiltering(true);
s.ColumnSetting().ColumnKey("TailNumbers").AllowFiltering(true);
s.ColumnSetting().ColumnKey("CompanyName").AllowFiltering(true);
s.ColumnSetting().ColumnKey("City").AllowFiltering(true);
s.ColumnSetting().ColumnKey("State").AllowFiltering(true);
s.ColumnSetting().ColumnKey("Status").AllowFiltering(false);
s.ColumnSetting().ColumnKey("Active").DefaultExpressions(activeFilterExpression).FilterType(FilterType.Bool).AllowFiltering(true); 
s.ColumnSetting().ColumnKey("Id").AllowFiltering(false);
});
f.Paging().Type(OpType.Remote).PageCountLimit(10000000).PageSize(25).RecordCountKey("TotalRecordsCount").PrevPageLabelText(StringResources.String_Previous).NextPageLabelText(StringResources.String_Next);
f.Sorting().Type(OpType.Remote).ColumnSettings(s =>
{
s.ColumnSetting().ColumnKey("Name").AllowSorting(true);
s.ColumnSetting().ColumnKey("TailNumbers").AllowSorting(false);
s.ColumnSetting().ColumnKey("CompanyName").AllowSorting(true);
s.ColumnSetting().ColumnKey("City").AllowSorting(true);
s.ColumnSetting().ColumnKey("State").AllowSorting(true);
s.ColumnSetting().ColumnKey("Active").AllowSorting(false);
s.ColumnSetting().ColumnKey("Id").AllowSorting(false);
});
})
.Height("99%")
.Width("100%")
.ResponseDataKey("Customers")
.DataSourceUrl(Url.Action("GetCustomerGridData"))
.DataBind()
.Render()

Could you please help me with this? Am I missing something?