Solved

Windows GUI - Filter in Grid (what steers functionality)

  • 24 November 2022
  • 2 replies
  • 60 views

Userlevel 5
Badge +16
  • Thinkwise Local Partner Brasil
  • 384 replies

What settings steer the functionality of filtering in the grid? 

I have 4 similar lookup fields,  ID with lookup to base table..  and as far as I can see 2 have a filter option like below and 2 don't..  what setting causes this difference?  I want all fields to have a similar filter option. 

 

 

icon

Best answer by Dick van den Brink 24 November 2022, 20:17

View original

This topic has been closed for comments

2 replies

Userlevel 5
Badge +16

Hi Freddy,

There are some occasions when the Excel style filter is not visible
-    When it is a blob type
-    When the control type is Multiline/RTF/HTML/SQLEditor/Password/Signature 
-    When Visible for filter is set to Never (column setting)
-    When the Field width (px) of the column is <= 0 (column setting)
Could one of the above be the case? 
 

Hi @Dick van den Brink 

Found it. The lookup from the ones that didn't work had a multi-line control type. 

So thanks! Problem solved. 

Userlevel 4
Badge +2

Hi Freddy,

There are some occasions when the Excel style filter is not visible
-    When it is a blob type
-    When the control type is Multiline/RTF/HTML/SQLEditor/Password/Signature 
-    When Visible for filter is set to Never (column setting)
-    When the Field width (px) of the column is <= 0 (column setting)
Could one of the above be the case?