For big dataset it could help a lot for the performance to avoid using 'LIKE’ in where clauses.
I wish a different behavior, depending on 'Filter Condition’ or an extra setting for this.
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)
When the Filter Condition is set to 'Equal to’
I would like to see this feature in Universal as well. Not only for optimizing performance, but also for a better user experience to prevent users from getting too many results when searching for specific data