Skip to Main Content
Feature Request FR-3368
Product Area Application Builder
Status CLOSED

8 Voters

Page Locking / Unlocking API

jason.aughenbaugh Internal · Sep 15 2023

Idea Summary
Provide an api to allow an application page to be locked from pl/sql.

Use Case
In multi developer environments we want to be able to lock pages in an application using plsql using an api

Preferred Solution (Optional)
Since the operation in apex internal code is fairly simple of adding and deleting this information on a specific table this could be exposed as part of the apex_util package.  just replicate the lock_page and unlock_page procedures from the wwv_flow_property_dev package

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • vincent morneau Admin OP 2.5 years ago

    Hi @jason.aughenbaugh ,

    Can you provide a real world use case for doing this?

  • jason.aughenbaugh OP 2.5 years ago

    This is the same scenario that we would lock a page through the builder.  A developer is working on a page and wants to exclude development on that page by other developers until finished.  In this case we want to:

    1.  use a separate tool to (de)activate the lock (ie. a Dev Manager Interface)
    2. Have the ability to force the unlock from outside the builder when a lock is left in place in error.
  • tjuarez OP 1.5 years ago

    In my case, it would be really helpfull. In my company, we developed our own  ERP (and more) system, which include a modulo for issues tracking, and ticket assigments. I would like to add a feature for developers to register pages associated to the ticket, and to lock that pages automatically, in order to avoid multiple developers working on the same page.

  • mcristobo OP 1.5 years ago

    Excellent initiative, it would be very useful for our development team.

  • emazzu OP 1.5 years ago

    Me parece muy buena idea. !!! y muy util.

  • shmuel.appleton OP 1.1 years ago

    This would also help with a current initiative in my organization, to reduce conflicts when multiple developers are working on the same application. In addition to an API, it would be nice to have a workspace setting to enforce page locking before making any changes, meaning pages in the app builder are by default locked by the system/read only until locked by a user.