Skip to Main Content
Feature Request FR-2608
Product Area Page Components
Status ROADMAP

38 Voters

Interactive Grid: Execution Scope = "All Submitted Rows" should submit all rows, not just new/modified rows

brian.d.hill Internal
· Jun 28 2022

Idea Summary
For an Interactive Grid (IG) - Automatic Row Processing (DML) page process, setting the Execution Scope should process every row from the IG.  Currently, it behaves exactly the same as “For Created and Modified Rows”.

Use Case
On our current Inventory project, we have a requirement on a page to let a user perform a “Save As” feature on a parent-child data set on the page.  This pattern occurs multiple times within their app.

For example, they could be looking at an Order with multiple Line Items.  The Order info is displayed in a header region while the Line Items are displayed in an editable IG.  They would like to be able to edit some of the Line Items and then click a “Save As” button which will copy the Order and save the edits *only to the new copy*.  On Save As, the original Order will remain untouched, and all changes will be written to the new Order and its Line Items.  Without the “All Submitted Rows” functionality, we can only process the modified rows - we will lose the unmodified ones.  There are work-arounds for this (like executing some JS to mark all rows as modified) but they are less preferable than something declarative.

Preferred Solution (Optional)
When Execution Scope = “For Created and Modified Rows”, the behavior should remain the same - process only created/modified rows in the IG.

When Execution Scope = “All Submitted Rows”, process every row from the IG.

I believe this is how it worked with Tabular Forms.

This is currently on the roadmap for a future release of Oracle APEX.

5 Comments

Comments

  • jayson hanes Admin OP 2.8 years ago

    this got me irritated back when working on the Pandemic Response apps, CoVPN and VPoP, but has obviously been an issue for longer.

  • joseassumpcao OP 2.7 years ago

    Is this a bug? What “All Submitted Rows” really does with IG? Also please add a option to process “All Selected Rows” and maybe put an option to not let multiple identical lines be submitted (both new lines or a set of new line(s) with existing one(s))

  • bshumway OP 2.6 years ago

    This feels like a bug.

    I have a perfect use case for “All Submitted Rows”. I need a validation that makes sure there is at least one row in the IG.

    On "Page Processing - After Submit" I set P10_HAS_ROWS = ‘Y’ in a process that is set to the editable region and all submitted rows.

    Then my validation checks if P10_HAS_ROWS = ‘Y’. 

    The issue is… if the user made no changed to the IG… then the process doesn't trigger and P10_HAS_ROWS is still its default value ‘N’.

    Please fix :)

  • jayson hanes Admin OP 2.6 years ago

    Well, it's only a bug if it behaves in a way that wasn't intended.. this behaves this way because it is intended to be this way as is – and is really just, “incomplete functionality”.

  • jayson hanes Admin OP 2.6 years ago

    FWIW, internally, Patrick and I have had this discussion but it's no secret: