Skip to Main Content
Feature Request FR-4546
Product Area Page Components
Status OPEN

7 Voters

Add a "Page Item to Store Selected Rows" as a native option for Interactive Grids

sjmackenzie40 Public · Jul 8 2025

Idea Summary
It would be great if there was an option to specify a page item in the Interactive Grid attributes, to specify a page item to store the selected rows in the interactive grid.

Use Case
You may want to filter a chart, or a separate report on the page based on the selections.  To be able to have row selections automatically add the relevant identifiers into a page item, to which a dynamic action could be attached would be a great time saver.  Ideally you would have options to specify which column in the underlying interactive grid is the ID, if there is no primary key specified.

This idea is open.

Comments

Comments

  • karel ekema OP 3 months ago (edited 3 months ago)

    See https://docs.oracle.com/en/database/oracle/apex/24.2/aexjs/grid.html#selectionStateItem

  • sjmackenzie40 OP 3 months ago

    Hi, thanks.  But I meant do it declaratively, not have to know the JavaScript API.  It’s a very common use case.

  • karel ekema OP 3 months ago

    You can set it like this in IG/Attributes/Initialization JavaScript Function:

    function( options ) {
   options.defaultGridViewOptions = {
       selectionStateItem: 'P53_SELECTION_STATE'
   };
   return options;
}

    Notice the use of JavaScript snippets is inherent to your choice of using Interactive Grid as a client-component. But I agree this option is used regularly.

  • sjmackenzie40 OP 3 months ago

    Thanks, which is why I thought a nice declarative option avoiding JavaScript would be a good idea. An attribute “Selected Rows Stored in” and an Item selector.

  • sjmackenzie40 OP 2 months ago

    Also, this doesnt let me capture the ID (or other column) value, it seems to be a row selector