Forum Stats

  • 3,874,594 Users
  • 2,266,750 Discussions
  • 7,911,908 Comments

Discussions

Region Customization - can you extract the page regions a user has selected

Nick Zed
Nick Zed Member Posts: 3
edited Apr 15, 2013 1:33AM in APEX Discussions
Is there an APEX view, or someway to determine programmatically, which customizable regions a user has selected?

In the case where we have set regions to be 'Customizable and Shown By Default', our application needs to know which regions a user has selected or de-selected, as the application processing logic will vary depending on the user selection.

Answers

  • Jorge Rimblas
    Jorge Rimblas Member Posts: 710 Bronze Trophy
    Here are some useful queries.

    To see all the views available.
    select *
    from apex_dictionary
    where column_id = 0
    Then the other column_id values are the actual columns on those views.

    So I ran this:
    select *
    from apex_dictionary
    where column_name like 'CUST%'
    And found a good candidate on view APEX_APPLICATION_PAGE_REGIONS

    You're looking at something like this:
    select region_name, customization, customization_name
    from APEX_APPLICATION_PAGE_REGIONS
    where application_id = :APP_ID
    Thanks
    -Jorge

    Please update your user name from user2543337 to something more friendly
  • Nick Zed
    Nick Zed Member Posts: 3
    Yes - we have looked at the apex_application_page_regions view and use that to determine which regions we have made Customizable (using the value in the CUSTOMIZE column) in the application.

    The question is a little more specific.

    Once a region has been configured to be customizable by the user - where can we go to find out which users have customized (ie, selected or de-selected) each region?

    We went looking for an apex view with a combination of region_id and some form of user_id but couldn't find anything.

    Any thoughts?
  • VC
    VC Member Posts: 2,413 Gold Trophy
    user2543337 wrote:
    We went looking for an apex view with a combination of region_id and some form of user_id but couldn't find anything.

    Any thoughts?
    I don't think there is a published view to query the user customization.

    But this might help {message:id=10382422}
  • Jorge Rimblas
    Jorge Rimblas Member Posts: 710 Bronze Trophy
    Sorry Nick, I must have read too fast and missed the right question.
    Looks like Vikram pointed you to the right answer already.
    -Jorge
  • Nick Zed
    Nick Zed Member Posts: 3
    Thanks everyone - that's solved my problem.

    I can use APEX_UTIL.GET_PREFERENCE to see the user Region Customization Setting.
This discussion has been closed.