Multiple Value Search/Filter does not work

[hardysonarthy]

I was unable to filter out multiple values from a column using either regex or server side extensions..
public override void OnDataProcessing(ref object itemList, RequestInfoModel requestInfoModel) { var dataAsQueryable = itemList as IQueryable<ChqReqIndexItemVM>; Column companyCodeCol = requestInfoModel.TableParameters.Columns.ElementAt(6); //6 - company code column if (!String.IsNullOrEmpty(companyCodeCol.Search.Value) && companyCodeCol.Search.Regex) { if (companyCodeCol.Search.Value.Contains('|')) { var splitQuery = companyCodeCol.Search.Value.Split('|').ToList(); itemList = dataAsQueryable.Where(c => c.CompanyCode == "SEBK" ); // splitQuery.Contains(c.CompanyCode)); } } }
I also have used OnColumnsFilterDataProcessing & OnColumnsFilterDataProcessed but to no avail. Please advise.