Skip to main content
Open

Filter Condition settings for Combined Filter

Related products:Software FactoryWindows GUIUniversal UIIndicium Service Tier
  • January 16, 2020
  • 1 reply
  • 191 views

Harm Horstman
Superhero
Forum|alt.badge.img+21

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’

 

1 reply

Forum|alt.badge.img+3
  • Thinkwiser
  • March 20, 2023

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