Skip to main content
Open

Filter Condition settings for Combined Filter

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

Harm Horstman
Superhero

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’

 

Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+3
  • Vanguard
  • 20 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings