APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn

 

Tips & Tricks

Print
05
Aug

Query the APEX Metadata - #1 - Identify Public Pages

Written by Richard Weug. Posted in Tips and Tricks

As i introduced the my APEX QA Plugin, i was asked if i could help other people to get some special information out of the metadata of APEX. Especially in APEX, where every configuration is saved in the database, it's really easy to get some information of your application only by using one sql query. Because of that i will release every month one query to identify some interesting stuff.

Of course if there are any interesting properties which you would like to query, pleas let me know.

A first simple example is, to identfiy all the pages which can be reached without authentication:

    select p.application_id
             ,p.page_id
             ,p.page_name
             ,p.last_updated_by
             ,p.last_updated_on
             ,p.created_by
             ,p.created_on
    from apex_application_pages p
    where p.page_requires_authentication = 'No'

The query returns all pages, of all applications in your workspace. If you run the query on a database schema all applications, conected to this schema will be referenced.
Needles to say, that there are always many columns in the APEX Views, but getting the name and some information like, who and when was the page was created and updated might be most useful.

Original article: Oliver Lemm