For big dataset it could help a lot for the performance to avoid using 'LIKE’ in where clauses.
I expected a different behavior, depending on 'Filter Condition’Â
Example:
Combined filter value: 2019 2020Â
Result:Â Â
SELECT .. FROM .. t1 WHERE (t1. ACC_YEAR] LIKE '%2019%’) or (t1.9ACC_YEAR] Like '%2020%’)
Should be:
SELECT .. FROM .. t1Â WHEREÂ (t1.MACC_YEAR] = 2019)Â or (t1.EACC_YEAR] = 2020)
Â
This is either a bug or a wish. The filter condition is only applied to the filter (right mouse button: filter) and not to the combined filter.Â
In my opinion it's a bug, but most users won't mention it, because it only is relavant for larger data sets.
The manual states: The Advanced option affects the expansion of the search/filter screens.Â
This implies that the filter condition is not used for the Combined filter. So please make a wish for this.Â
Ok, I will do
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.