Skip to main content

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

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

Kind regards,

Linde
 

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

 

 

Terms & ConditionsCookie settings