Current filter:
                                You should refresh the page.
                                  • Hi,

                                    How do I use custom DropDown value and also run the Contains in Data filter row option as default.
                                    Please see the below code where the ComboBox overrides the AutoFilter and the results are not as desired.
                                    Please let me know soon.
                                    Thanks in advance.

                                                settings.Columns.Add(column =>
                                                {
                                                    column.FieldName = "UpdateContent";
                                                    column.Width = Unit.Percentage(24);
                                                    column.ExportWidth = 90;
                                                    column.HeaderStyle.Wrap = DefaultBoolean.True;
                                                    column.Settings.AllowSort = DefaultBoolean.False;
                                                    column.Settings.AutoFilterCondition = AutoFilterCondition.Contains;

                                                    column.ColumnType = MVCxGridViewColumnType.ComboBox;
                                                    var comboBoxProperties = column.PropertiesEdit as ComboBoxProperties;
                                                    comboBoxProperties.DataSource = ReportsHelper.GetStatusTypes();
                                                    comboBoxProperties.ValueType = typeof(string);
                                                    comboBoxProperties.DropDownStyle = DropDownStyle.DropDown;
                                                });

                                2 Solutions

                                Creation Date Importance Sort by

                                I found this was the best way to solve this type of problem:

                                settings.ProcessColumnAutoFilter += (s, e) =>
                                        {
                                            if (e.Column.FieldName == "MyColumnName")
                                            {
                                                // Clear previous filter
                                                var gv = s as MVCxGridView;
                                                if (gv != null)
                                                    //gv.FilterExpression = string.Empty;

                                                if (e.Kind == GridViewAutoFilterEventKind.CreateCriteria && !String.IsNullOrEmpty(e.Value))
                                                {
                                                    e.Criteria = DevExpress.Data.Filtering.CriteriaOperator.Parse("Contains([MyColumnName], ?)", e.Value);
                                                }
                                            }

                                        };

                                HI,

                                The DropDown value should be applied correctly in your code. As for the "contains" condition, it is necessary to manually change the criteria in the ProcessColumnAutoFilter event handler as it is shown in T157260: ASPxGridView - Filter by ASPxComboBox/GridViewDataComboBoxColumn and AutoFilterCondition CONTAINS:

                                [C#]
                                settings.ProcessColumnAutoFilter += (s, e) => { if (e.Kind == GridViewAutoFilterEventKind.CreateCriteria) { if (e.Column.FieldName == "A") { if (!string.IsNullOrEmpty(e.Value)) { DevExpress.Data.Filtering.BinaryOperator binop = new DevExpress.Data.Filtering.BinaryOperator("A", string.Format("%{0}%", e.Value), DevExpress.Data.Filtering.BinaryOperatorType.Like); e.Criteria = binop; } } } else { if (e.Column.FieldName == "A") { var binop = e.Criteria as DevExpress.Data.Filtering.BinaryOperator; e.Value = binop.RightOperand.ToString().Replace("%", "").Replace("'", ""); } } };

                                The code above uses the "A" field name. Change it to your "UpdateContent" field.