Solved

Combined Filter Conditions

  • 15 January 2020
  • 4 replies
  • 80 views

Userlevel 6
Badge +14

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’ 

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)

 

icon

Best answer by Erwin Ekkel 16 January 2020, 08:57

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. 

View original

4 replies

Userlevel 6
Badge +8

This is either a bug or a wish. The filter condition is only applied to the filter (right mouse button: filter) and not to the combined filter. 

Userlevel 6
Badge +14

In my opinion it's a bug, but most users won't mention it, because it only is relavant for larger data sets.

Userlevel 6
Badge +8

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. 

Userlevel 6
Badge +14

Ok, I will do

Reply