I have to reports on page. There is a checkbox apex_item.checkbox column, where requirement is when I click on checkbox the row should automatically get to the other report. Now, I'm aware checkboxes shouldn't normally be used to do any server side processing or perform Database actions if not using submit, but still a requirement
In this case, can it be done by adding Dynamic Action -> On Click of -> jQuerySelector: input:checkbox (or some other reference to each of the report's checkbox column items) -> Submit action, and then add ing submit process which will consist of PL/SQL code that will update table column for some status going through G_Fx where checkbox is checked, page will get refreshed/branched back, and reports will both show data based on column status updated, so basically row would get moved from one report to another based on that status?
you can use this technique Re: Checkbox in Apex Interactive Report . If you had any difficulties, I would suggest to create a showcase on apex.oracle.com (if you don't have a workspace yet, make a request for the new one).