Some time ago a customer asked me if it was possible to have a sitemap on a developed application. Of course one could make a static sitemap and update it each time pages are added/changed but having a generic solution would make life so much easier.
This was again an excellent opportunity to make use of the apex dictionary views, seeing I consistently made use of the breadcrumbs, it just was a matter of getting the right query for the correct info. Once I have this info I could use the ApEx Tree option to represent it.
After some trial & error I came up with this:
SELECT breadcrumb_entry_id id,
WHERE application_id = v(‘APP_ID’)
Now I made a view on this query: v_sitemap
When you make the tree base it on your view and make sure you choose as root value the option static assignment with value 0.
All done and now you have a nice sitemap for your application.