1 Reply Latest reply on Oct 11, 2018 6:17 AM by Franck N

    (APEX) How to make "Null Return Value" returns more signs?

    3740337

      (APEX v. 5.1.1.00.08; DB 11G)

       

      Hi,

       

      I have problem with „select list item” on my APEX page. There is effect selector with 70+ effects. There is no way to make it less. I would like to add „ALL” option. In section „List of Values” is option „Null Return Value”. I tryied to put there effects ID and it works but I have more ID then I can put there.

       

      Is there any way to put more ID?

       

      Thank in advance for help :-)

       

      P.S. Images to show where the problem is. Maybe it will help :-)

       

        • 1. Re: (APEX) How to make "Null Return Value" returns more signs?
          Franck N

          Hi,

           

          no it wont work that way. The question is where are you using that Item?

          because it all depend on the purpose of it.

           

          if in an SQL Querry? i will suggest that you return the String "all" if the Item doesn´t have an Integer constrain. If it does then return 0 or empty for Null.

           

          then where ever you are using that item just add a checking there like bellow.

          begin

          if : P3_ITEM is null then

          select .........

          end;

           

          we could have a better answer depending on your use case.

           

          regards,

          Franck