This question seems so simple but I cannot find any reference to it in the knowledge base. I need to filter the rows in a grid based on one column's equality to another column. Example might be "where column_a not equal to column_b". How can I accomplish this?
Shouldn't this be possible using the create filter option when ShowFilterBar is true?
Proposed Solution:
add a checkbox or combo next to condition:
Quantity Is greater than [x] column Store
here [x] column is a checkbox
or it can be a "column/value" combobox
We have closed this ticket because another page addresses its subject:
ASPxFilterControl - Provide the capability to compare filter values among themselvesASPxFilterControl - Allow construct rules [Column1] [operation] [Column2] like in WinForms
Answers approved by DevExpress Support
Hello,
We have implemented the Operand Type button, which allows end-users to select an operand type: a value or another field's value. Please refer to the ASPxFilterControl - Provide the capability to compare filter values among themselves thread for more information. You can see this functionality in action in the How to construct rules like [Column1] [operation] [Column2] in ASPxGridView FilterBuilder example.