Solved

Custom menu condition

  • 4 February 2020
  • 2 replies
  • 792 views
M
Rank
Badge +2

I have created custom menus in several screens, and they are working. But for one custom menu I want it to display only there is a value in a specific field. Therefore, I used conditions. But seems the custom menu is not accepting the condition. I have tried most of the conditions in below site.
https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm

Ex: 
MINIMUM_QTY IS NOT NULL
MINIMUM_QTY <> NULL
MINIMUM_QTY != NULL
MINIMUM_QTY = “”
MINIMUM_QTY = ‘’

 

 

The custom menu when no value

 

 

The custom menu with value

 

 

If you have faced similar, please share your findings.

icon

Best answer by Sandun Madola 4 February 2020, 07:44

View original

2 replies

Sandun Madola
Rank
Userlevel 6
Badge +13

Have you tried below
MINIMUM_QTY %
 

For example, if I need my custom menu to enable only when ‘Catalog No’ has a value I use the condition CATALOG_NO %

‘%’ defines any value. You need not put equal sign before the ‘%’.

 

 

M
Rank
Badge +2

Have you tried below
MINIMUM_QTY %
 

For example, if I need my custom menu to enable only when ‘Catalog No’ has a value I use the condition CATALOG_NO %

‘%’ defines any value. You need not put equal sign before the ‘%’.

 

 

Fantastic. It’s simple and working. Thank you @Sandun Madola 

Reply


Terms & ConditionsCookie settings