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’
Combined filter value: 2019 2020
SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] LIKE '%2019%’) or (t1.[ACC_YEAR] Like '%2020%’)
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.