Skip to main content
Solved

Custom menu condition

  • February 4, 2020
  • 2 replies
  • 937 views
M
Do Gooder
Forum|alt.badge.img+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.

Best answer by Sandun Madola

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 ‘%’.

 

 

    2 replies

    Sandun Madola
    Hero (Employee)
    Forum|alt.badge.img+13
    • Sandun Madola
    • Hero (Employee)
    • 145 replies
    • Answer
    • February 4, 2020

    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
    Do Gooder
    Forum|alt.badge.img+2
    • Maria
    • Author
    • Do Gooder
    • 1 reply
    • February 5, 2020

    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 


    Terms & ConditionsCookie settingsAccessibility statement