4 Replies Latest reply on Jun 30, 2015 6:52 PM by fac586

    Dynamic navigation list APEX 5

    HarryF

      I created a list based on a SQL query. I want to replace the APEX 5 navigation list. How do I do that? When I go to navigation menu or navigation bar list I see create or copy, I don't see an option to use my list.

        • 1. Re: Dynamic navigation list APEX 5
          SalimWer

          Hi

           

          1- Create a navigation list

          go to your application shared components->Navigation->Navigation Menu

          Create a new list from scratch of type Dynamic, then choose SQL QUERY as your query source type

          enter your query that should have the following columns "level","label" , "target", "is_current", "image"

           

          example:

           

          select LEVEL "level",

                 PRV_NAME  "label",

                decode(connect_by_isleaf,0, '','f?p=&APP_ID.:'||TO_CHAR(PRV_APEX_PAGE)||':&SESSION.:::::')  "target" ,

                  'YES'  "is_current",

                 decode(nvl(PRV_ICON_IMG,'A'),'A','',PRV_ICON_IMG)  "image"

          from ADMN_PRIVILEGES

          start with "PRV_ID_PRNT" = 10000

          connect by prior "PRV_ID" = "PRV_ID_PRNT"

          order siblings by PRV_NAME desc

          then select do not Create List Regions.

           

          2- in your page designer go to Navigation Menu->Override User Interface Level

          and change it to YES,

          the following  option will be enabled

          LIST select the navigation created in step 1

          then

          LIST Position : Side

          LIST Template : your template


          Hope this will help you

          Salim

          • 2. Re: Dynamic navigation list APEX 5
            HarryF

            That works but does that mean I need to do that in every page? Is there a way to do that at the application level?

             

            harry

            • 3. Re: Dynamic navigation list APEX 5
              SalimWer

              Yes, we have to do this in every page, in apex 4.2 I used to create a list region in page 0, but when moved to apex 5, I found that the new navigation menu is more user friendly even if it requires more work

               

              Regards

              Salim

              • 4. Re: Dynamic navigation list APEX 5
                fac586

                HarryF wrote:

                 

                That works but does that mean I need to do that in every page? Is there a way to do that at the application level?

                Yes, of course there is. Go to the Desktop user interface detail page, and select the new list in the navigation menu Navigation Menu List attribute.

                 

                This is completely misinformed:

                SalimWer wrote:

                 

                2- in your page designer go to Navigation Menu->Override User Interface Level

                and change it to YES,

                the following  option will be enabled

                LIST select the navigation created in step 1

                then

                LIST Position : Side

                LIST Template : your template

                Yes, we have to do this in every page, in apex 4.2 I used to create a list region in page 0, but when moved to apex 5, I found that the new navigation menu is more user friendly even if it requires more work