is it possible to modify a filter value before the SQL is executed.
For example if a model has a string field, the user can select the field in the filter view and enter a string value. I want to change that string value, so that the new one is used in the SQL query.
Is there a hook, would it be possible to solve this via custom datatype or is there another solution?
Thanks in advance.