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

1 Voters

Do not use NEXTVAL of sequence on Create Application/Page wizards

appex Public · Dec 25 2024

Idea Summary
Application ID and Page ID are wasted if we cancel out of the create wizard

Use Case
While creating a new application or page, it auto-generates an app/page ID in the wizard. But if we cancel the wizard, the generated ID gets wasted as it uses NEXTVAL on the sequence to generate. If we reopen the wizard, we can see that the ID got incremented again even though the last creation step was canceled.

Preferred Solution (Optional)
Use sequence.CURRVAL+1 to generate the IDs in the create wizard and use NEXTVAL while saving the app/page so if we cancel the wizard, the NEXTVAL remains intact and does not get wasted.

NOTE: We can still use the wasted ID by manually specifying the ID in the wizard but the above suggestion would be more graceful.

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 4 months ago

    This would certainly be a nice improvement to avoid gaps in the sequence, we determined that it cannot be prioritized right now. Hopefully we can revisit in the future.