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?
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.