Current filter:
                                You should refresh the page.
                                  • I populate my DataGrid using dynamic linq like this.

                                    SELECT new (OrderNum, CustomerID, Customer.AcNum as AcNum, Customer.Name as CustomerName) FROM Order

                                    My DataGrid has columns using fields AcNum and CustomerName.  They can be displayed successfully.  However when user is using header filter, the filter expression uses AcNum to search for records and that causes failure in Linq.  It must use Customer.AcNum instead of AcNum for Linq to work.  How can I use a different field (Customer.AcNum) in filter operation?

                                • Alisher (DevExpress Support) 11.22.2019

                                  Hi Edwin,

                                  The DataGrid widget provides the functionality to specify a column's custom filtering rules by using the calculateFilterExpression function, however, you cannot use the value of another column in the target column by using this function. Please describe your business scenario in greater detail. I will do my best to find an appropriate solution for you.

                                1 Solution

                                Creation Date Importance Sort by

                                I figured out that the header filter uses "DataField" for searching.  Therefore I set

                                DataField = Customer.AcNum
                                CalculateDisplayValue = AcNum
                                CalculateSortValue = Customer.AcNum

                                • Alessandro (DevExpress Support) 12.03.2019


                                  It is good news that the problem has been resolved. Thank you for letting us know about your progress. Please feel free to contact us if you have any further difficulties. We will be happy to assist you.