In APEX 5, is there a easy way of storing the PK of the records returned from an IR into a DB table. So if the user has added filters etc., I would only want to store the current records being returned in the IR.
For example.
If my IR SQL source is this (see below), I want to store all the empno values into a Oracle table. This can be executed from a custom button I can add on the IR region.
select empno, dept
from emp