javascriptfrontendoracle-apexinteractive-grid

How to call groupBy actions on Interactive Grid/Interactive Reports with JavaScript Dynamic Action in Oracle APEX?


I am using Oracle APEX 23.1.0, and I have an interactive grid/interactive report region. I want to make a button that groups the data by some predetermined columns COL1 and COL2, and count the number of rows in each group. The problem is that I want to do all this with a JavaScript dynamic action that is triggered when some button I placed is clicked.

I have not been able to find any information in the documentation on how to find the possible actions or how to execute them. Is this possible?


Solution

  • For the sake of simplicity, lets take an interactive report. I have not tested this approach for a read only interactive grid.

    These are the steps:

    You have not mentioned what you want to do with the results so can't really tell you more. For an example on how to use a APEX_REGION.OPEN_QUERY_CONTEXT, check this blog.