Dynamic Navigation Bar with custom Settings

I was trying the solution given by Roel, to fix parent child relation in APEX 5 Dynamic Navigation Bar.

Create-navigation-bar-based-on-sql

We had few more thoughts, why not try more customized template based on SQL.

So we made few changes in the backend so that Tooltip and Custom Icon settings can be used dynamically by the template.  While trying this we noted Image Alt Attribute is not available in the template. So we choose to use custom attribute for that as well.

Below is the description of the custom attributes we used. A03 will be used to Tooltip class.

Image Attribute currently is not used in Navigation Bar template.

Adding Tooltip Class and Image attribute to the template both for without and with sublist.

For tooltip we used APEX Tooltip. And the final result look like

  

    

Finally we have a template which is fully controlled based on data in backend.

Still trying to do further customization here and will update in next post.