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.9ACC_YEAR] LIKE '%2020%’)
Should be:
SELECT .. FROM .. t1Â WHEREÂ (t1. ACC_YEAR] = 2019)Â or (t1.AACC_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