Skip to Main Content
Feature Request FR-3540
Product Area Page Components
Status CLOSED

2 Voters

Interactive Grid to allow DML operation on collection

santosh sonawane Public · Dec 8 2023

Idea Summary
To enable DML operations in the interactive grid, it currently issues a warning with a "yes" or "no" option. However, this approach is not user-friendly, as users typically press the save button once all data entry is completed. Upon clicking the save button, the intention is to insert the data into the actual tables.

Use Case
 This will be helpful when creating a master-detail page manually using Apex collections, such as in a sales invoice. In this scenario, the page includes header information and details like product code, name, quantity, price, tax, etc. Each invoice can comprise multiple products, and during data entry, users can dynamically add, edit, or delete lines using an interactive grid. 

currently we tried to do DML using dynamic action and ajax and then refresh region but  warning with a "yes" or "no" is bothering user .

Preferred Solution (Optional)
How would you implement this idea? If you are not sure, leave blank.

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

  • carsten.czarski APEX Team OP 2.2 years ago

    Well, by changing the Target of your Interactive Grid DML process to PL/SQL, you can easily build your DML logic on Collections yourself. It's actually very easy and straightforward using the APEX_COLLECTION API …