For these favorites we can query the APEX repository. Follow these steps to get this thing working:
- Enable logging on Application Level. Enabling the logging will result in records in the view apex_workspace_activity_log.
- Create a Report Page with a region based on a SQL Query.
- Enter the query to show the links for the three most visited pages:
select htf.anchor( 'f?p='||:APP_ID||':'||page_id||':'||:APP_SESSIONIn a next post I will show how you can embed this report page in any other page in your application.
, page_name ) Task
where application_id = :APP_ID
and apex_user = :APP_USER
and page_id <> :APP_PAGE_ID
group by page_name, page_id
order by 3 desc
where rownum <= 3