Hi,
I have a question about filtering the grid. In general, when the filter condition is entered, the request parameters are sent to the server to execute the relevant SQL. The problem now is that some of the fields displayed on my page are done under the function “beforeLoadComplete”, and the database has no related fields. For example, the database has two fields, “unit price” and “quantity”, and there is no “total price” field. The “total price” is added in “beforeLoadComplete” and displayed in the grid.
Now, when I enter the filter condition in the “Total Price” field, the query condition of the server SQL will be triggered, but the actual database does not have this field, so an error will be reported. How can I make a column filter only on the visible grid when filtering?
