I've a page which contains 3 report regions each one with a checkbox column. User has the flexibility to select any/all rows from each region and I need to store the selected rows into a database table.
I've created the below process to insert the data into the table.
FOR i in 1..APEX_APPLICATION.G_F01.count
insert into table_name (c1,c2,c3) values (v1, APEX_APPLICATION.G_F01(i),v3);
The process is executing well and inserting the data into the table. But the problem is when the user select rows from different regions, I get all rows inserted into the tables but I'm not able to identify which row is selected in which region. Is there any way to identify the region from where the row is checked.
Thanks in advance for the help.
Your probably using apex_item package to generate checkboxes. So, try to change p_idx parameter.
In your case it's probably p_idx => 1. In other 2 reports set it to 2 and 3 and then in process you can fetch that with in APEX_APPLICATION.G_F02 and APEX_APPLICATION.G_F03 arrays.