Skip to main content
Solved

Custom menu condition

  • February 4, 2020
  • 2 replies
  • 919 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 ‘%’.

 

 

View original
    Did this topic help you find an answer to your question?

    2 replies

    Sandun Madola
    Hero (Employee)
    Forum|alt.badge.img+13
    • Sandun Madola
    • Hero (Employee)
    • 144 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 ‘%’.

     

     

    Yasas Kasthuriarachchi
    SORSITEL
    M
    4 people like this
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi
    • SORSITEL
      SORSITEL
    • M
      Maria
    • dewelk
      dewelk
    M
    Do Gooder
    Forum|alt.badge.img+2
    • Maria
    • Author
    • Do Gooder
    • 1 reply
    • February 5, 2020
    Sandun Madola wrote:

    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 

    Sandun Madola
    Yasas Kasthuriarachchi
    2 people like this
    • Sandun Madola
      Sandun Madola
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi

    Reply


    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings