To add dropdown in filterrow | Infragistics Forums

I am following your sample project for adding drop down in filter on few of column on my iggrid. In my case i am using remote filtering which causing problem. Below is the test case.

Let’s say there are 4 column (“DeclarationNo”, “ArticleNo”, “ArticleName” , “SiteName”) of my grid.
Now I am setting filter on” DeclarationNo” column, I am able to send the select value to controller.
Now I am selecting value from “ArticleNo” column dropdown filter, still I can see the both “ID” and “CITY” value in controller.
But the moment I try to filter something on “Article Name” in my controller I can see there is nothing in “ArticleNo” filters.

Below is code details.

function BindGrid(stateReferenceId, responsedata) {

var combodata = JSON.parse(responsedata)

$('#declarationGrid').igGrid({

width: "100%",

dataSource: "/Declaration/GetPagedData?stateReferenceId=" + stateReferenceId,

responseDataKey: "Data.data",

autoGenerateLayouts: false,

autoGenerateColumns: false,

columns: [

{ headerText: "No", key: "DeclarationNo", dataType: "number", template: "<a href='http://localhost:14152/Home/Sample/1' > ${DeclarationNo} </a>" },

{ headerText: "Article No", key: "ArticleNo", template: "<a href='http://localhost:14152/Home/Sample/1' > ${ArticleNo} </a>" },

{ headerText: "Article Name", key: "ArticleName", template: "<a href='http://localhost:14152/Home/Sample/1' > ${ArticleName} </a>" },

{ headerText: "Site Name", key: "SiteName", template: "<a href='http://localhost:14152/Home/Sample/1' > ${SiteName} </a>" },

features: [

{

filterExprUrlKey: 'filter',

filterLogicUrlKey: 'filterLogic',

caseSensitive: false,

name: 'Filtering',

type: "remote",

advancedModeEditorsVisible: true,

columnSettings: [

{

columnKey: "ArticleNo",

allowFiltering: false,

]

});

var articleNos = [];

var type = [];

var lang = [];

var vale = '';

$.each(combodata.Data.data, function (index, value) {

if (value.ArticleNo !== null)

if (articleNos.indexOf(value.ArticleNo) === -1)

articleNos.push(value.ArticleNo);

if (value.Type !== null)

if (type.indexOf(value.Type) === -1)

type.push(value.Type);

if (value.Language !== null)

if (lang.indexOf(value.Language) === -1)

lang.push(value.Language);

});

$($('tr[data-role="filterrow"] td')[1]).append("<div id='filterArticalNoCombo'></div>");

$("#filterArticalNoCombo").igCombo({

dataSource: articleNos,

multiSelection: "onWithCheckboxes",

width: "100%",

top: "20px",

selectionChanged: function (evt, ui) {

var expressions = $("#declarationGrid").data("igGrid").dataSource.settings.filtering.expressions;

$("#declarationGrid").data("igGrid").dataSource.settings.filtering.expressions = [];

var newExpressions = [];

// first delete all expressions for this column

for (var i = 0; i < expressions.length; i++) {

if (expressions[i].fieldName !== "ArticleNo")

newExpressions.push(expressions[i]);

}

if (ui.items !== null) {

var itemsLength = ui.items.length;

for (var i = 0; i < itemsLength; i++) {

vale += ui.items[i].value + ',';

}

newExpressions.push({ fieldName: "ArticleNo", expr: vale, cond: "equals", logic: "AND" });

}

$("#declarationGrid").igGridFiltering("filter", newExpressions);

}

});

}

public dynamic GetPagedData(int stateReferenceId, int pageSize = 10, int pageIndex = 0, string sortField = "", bool isAscending = false, List<GridFilterCondition> gridFilter = null )

{

JavaScriptSerializer ser = new JavaScriptSerializer();

var datalist = _sampleDataProvider.GetData();

var pagedData = datalist.Skip(pageIndex * pageSize).Take(pageSize).ToList();

var jsonDataObj = Json(new

{

recordCountKey = datalist.Count(),

responseDataKey = "data",

data = pagedData

});

string jsonData = ser.Serialize(jsonDataObj);

return jsonData;

}