Posts

Showing posts from May, 2013

Global list region conditions

Quite often then not, I'm adding a list region onto the global page (page 0), and specifying the condition: Current Page Is Contained Within Expression 1 (comma delimited list of pages). The trouble with this is that each time you add a new list entry, you then need to go back to page 0, edit the region conditions, and update the list of pages. Then if you delete an entry from the list, you need to remember to go and update it. It's just occured to me there has to be a simpler way where you can just query the data dictionary to get the pages list, and check if it exists in that. When you specify the target type as 'Page in this application', you will notice that the column 'entry_target' returns the URL (or similar): f?p=&APP_ID.:14:&SESSION.::&DEBUG.:::: where 14 is the page you specified. So, we can get a list of pages the list relates to with a query similar to the following: select regexp_substr(apex_application_list_entries.entry_targe