Solved

filter condition 'between' not visiable in GUI 2023.3

  • 19 December 2023
  • 2 replies
  • 58 views

Userlevel 3
Badge

Hi, 

I want to add a filter form to a screen to make it possible to filter the results. in the grid. since the added_on is generated, i can't use it in the filter form. I added a lookup field to show the generated added_on field with the following expression: 

(select cast(convert(varchar(11), added_on, 105) as nvarchar))

The expression field has the domain ‘name’ which is a NVARCHAR(200). 

 

In subjects i've set the filter condition to ‘Between', but it only shows ‘Equal to’ in the grid. I can change it to ‘Contains’ and this does change and shows in the GUI. 

 

I would like to know what i can do.

Kind regards,

Linde

icon

Best answer by rbiram 19 December 2023, 11:04

View original

This topic has been closed for comments

2 replies

Userlevel 3
Badge

I just read it´s implemented in the new GUI, is that correct? 

Kind regards,

Linde
 

Userlevel 6
Badge +3

Yes :)

 

In this release, we have further improved the Universal GUI's filtering capabilities.

In the filter forms, we have expanded the support for filter conditions with the following operators:

  • Is empty
  • Is not Empty
  • Does not contain
  • Does not end with
  • Does not start with
  • Between
  • Not between