+21For 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.[ACC_YEAR] Like '%2020%’)
Should be:
SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] = 2019) or (t1.[ACC_YEAR] = 2020)
Best answer by Erwin Ekkel
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.
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.
+21In 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
