Skip to main content
Solved

Windows GUI - Filter in Grid (what steers functionality)

  • November 24, 2022
  • 2 replies
  • 64 views

Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • 528 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. 

 

 

Best answer by Dick van den Brink

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? 
 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Forum|alt.badge.img+3

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? 
 


Freddy
Forum|alt.badge.img+16
  • Author
  • Thinkwise Local Partner Brasil
  • 528 replies
  • November 25, 2022
Dick van den Brink wrote:

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. 


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