Navigation Tabs in APEX 4.2.x as List element

Render tabs in your application from a list query

How to create page navigation similar to APEX 5.0?

Just a useful info about how you can render you tabs based on query based LIST element.

One of the most important thing before creating your application is to consider the navigation options you will have. Most common way of doing this in pre 5.0 version was by using application tabs. 

In this post I will not go into details how you can render tabs in APEX applications as it is more or less self explanatory.

Ideally wouldn't it be great if you could have your Tab elements rendering from your database queries? 

This is exactly what I will be concentrating on.

To start with you need to create an application with Page 0

then you need to create a list using a query: 

 SELECT null,
       'Home' label,
       'f?p=&APP_ID.:1:'||:APP_SESSION||':::::' target,
       null is_current
FROM  dual
union
SELECT null,
       'Page2' label,
       'f?p=&APP_ID.:2:'||:APP_SESSION||':::::' target,
       null is_current
FROM  dual

Next thing is to create a region on Page 0 that will be using this -> List region with No Template option. 

And a display point set to After Header. Please note this will need to be changed before your tabs will be working.

All that is needed more to make this work is to change application Theme default page type by going into Shared components -> Themes -> Blue Responsive 25 -> Edit Theme


Go back to page 0 and change Display point of you List region to be Region Position 06.  Apply changes and run your application.

That is it.
:)

SLino