Hi Tristan,

You can configure the filter condition at project version and subject/column level. Which one are you using?

What platform and GUI version are you using?

Best regards,
Erik

Hi Erik,

We set the filters at subject/column level. We use platform Universal and version 2022.2.14

You mentioned the usage of a combobox. Do you mean, the column is the target of a lookup reference of a domain with elements?

Hi Erik,

No this isnt the case, the column holds for example material length's so values could be: 1000, 2500 and 3000. We would then like to see a combobox holding these values and filtering the grid when selecting one.

Hope this is clear

Regards Tristan

The GUI will load the column definition with its filter condition by requesting the `i_ui_col` view of SF/IAM. What is the result of this query:
 

SELECT  gui_appl_id]
      ,,tab_id]
      ,,tab_variant_id]
      ,,col_id]
      ,,dom_id],,visible_for_filter]
      ,,filter_condition]
      ,,filter_order_no]
      ,,dttp_type]
      ,,control_id]
      ,,col_id_transl]
  FROM  UNIVERSAL_SF]..dbo]..i_ui_col]
  WHERE tab_id = '...' and col_id = '...'

In addition, we did some improvement to the chosen filter condition in the 2022.2.15.0 release of the GUI. You can give that one a try too.

SELECT  gui_appl_id]
      ,,tab_id]
      ,,tab_variant_id]
      ,,col_id]
      ,,dom_id],,visible_for_filter]
      ,,filter_condition]
      ,,filter_order_no]
      ,,dttp_type]
      ,,control_id]
      ,,col_id_transl]
  FROM  UNIVERSAL_SF]..dbo]..i_ui_col]
  WHERE tab_id = '...' and col_id = '...'

Hello Erik,

thanks for your reply, what value should I use for tab_id? One of the query results (with tab_id = 'gui_col’) is this. Is this as expected?

6    gui_col        length    NULL    0    NULL    47    0    NULL    Length

Thanks

Tristan

“tab_id” references to the id of the subject of this case and "col_id” to the id of the column you filter on. 

Any updates on this one? Or do you need us to take a look at this with you?

This issue is fixed with the new 2022.2.15.0 release of the GUI, thanks for assisting!

Greetings Tristan