Forum Stats

  • 3,817,327 Users
  • 2,259,314 Discussions
  • 7,893,750 Comments

Discussions

Access shared component list in query

cwell
cwell Member Posts: 13
edited Jul 30, 2019 10:28AM in APEX Discussions

We are looking to set up a search bar so that pages can be searched for based on their titles. For this we thought it would be possible to use the lists in the shared components and from there get the target, the question we have is:

Can we access the list in the shared components (not list of values, but list under the navigation heading)?

Any help would be much appreciated.

Tagged:

Answers

  • fac586
    fac586 Senior Technical Architect Member Posts: 20,838 Red Diamond
    edited Jul 30, 2019 10:28AM
    cwell wrote:We are looking to set up a search bar so that pages can be searched for based on their titles. For this we thought it would be possible to use the lists in the shared components and from there get the target, the question we have is:Can we access the list in the shared components (not list of values, but list under the navigation heading)?

    Documented, public access to all of the application metadata is available through the APEX metadata views. You can get an overview of these using the query

    select * from apex_dictionary

    in Home > SQL Workshop > SQL Commands.

    Structured access to the APEX views is available through the Application Express Views utility at Home > Utilities > Application Express Views (switch to Tree view to get the best idea of how these are organised).

    The information required is available in the APEX_APPLICATION_PAGES, APEX_APPLICATION_LISTS, and APEX_APPLICATION_LIST_ENTRIES views.