Filtering a DevExpress XtraGrid's PopupList column

Question

Below&nbsp;are simplified methods for setting a filter on a DevExpress XtraGrid column.&nbsp; The code works when the column filter is a textbox, but it doesn't work when the column is a PopupList.&nbsp; Any suggestions for how to handle that scenario?function SetFilter(xtraGrid, columnId, filterValue){&nbsp;&nbsp;&nbsp;&nbsp;var column = GetColumn(xtraGrid, grid["DefaultView"], columnId);&nbsp;&nbsp;&nbsp;&nbsp;xtraGrid["DefaultView"]["SetFilterRowValue"](column, filterValue);}function GetColumn(grid, view, columnId){&nbsp;&nbsp;&nbsp;&nbsp;var columns;&nbsp;&nbsp;&nbsp;&nbsp;var col;&nbsp;&nbsp;&nbsp;&nbsp;if (view == null)&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;view = grid["DefaultView"];&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;columns = view["Columns"];&nbsp;&nbsp;&nbsp;&nbsp;if (aqObject["GetVarType"](columnId) == varOleStr)&nbsp;&nbsp;&nbsp;&nbsp;// The column is specified by caption&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (var i=0; i&lt;columns["Count"]; i++)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;col = columns["Item_2"](i);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (col["Caption"]["OleValue"] == columnId)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return col;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Column found&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return null;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Column not found&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return columns["Item_2"](columnId);&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;The column is specified by index&nbsp;&nbsp;&nbsp;&nbsp;}}

Answer

Do we have a Guru in Developer Express controls' testing? I think, there should be special properties/methods to access the needed entry.

BTW, Scott, did you see the "Filter XtraGrid data" How To article?

scottcm · Answer

I did see that code and it's the basis for the code I wrote. I ended up figuring out the problem, but there is more than 1 possible solution.

The easiest solution if you have control over the applications source code is to change the XtraGrid to filter by display text rather than value. I didn't have that option so I created a check for the type of editor used by the column filter and based on that either used text or looked up the "Id" value of the selection.

The code snippet ended up looking like this.

column = GetGridColumn(grid, view, columnId);

if (column["ColumnEdit"] != null && column["ColumnEdit"]["EditorTypeName"] == "PopupList")

{

filterValue = GetIdValueFromDataSource(column["ColumnEdit"]["DataSource"], displayText);

}

else if (column["ReadColumnEdit"]!=null && column["ReadColumnEdit"]["EditorTypeName"] == "PopupList")

{

filterValue = GetIdValueFromDataSource(column["ReadColumnEdit"]["DataSource"], displayText);

}

else

{

filterValue = displayText;

}

view["SetFilterRowValue"](column, filterValue);

Forum Discussion

Filtering a DevExpress XtraGrid's PopupList column

Related Content

Developer express Xtragrid add new row and set value

Problem with DevExpress XtraGrid - new row insertion

Schema Filter based on Method

Devexpress 15.2.4

Cannot get background color of a DevExpress XtraGrid cell

Recent Discussions

Onscreen Object Selector Slowness

aqObject.CheckProperty() slowness

Problem with generated data table and keyword test

WebView2 support does not work

System checks for Object for every test