Skip to main content
Answer

filter condition 'between' not visiable in GUI 2023.3

  • December 19, 2023
  • 2 replies
  • 82 views

Forum|alt.badge.img+1

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

Best answer by rbiram

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

 

 

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+1

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

Kind regards,

Linde
 


rbiram
Hero
Forum|alt.badge.img+4
  • Hero
  • Answer
  • December 19, 2023

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