Page 1 of 1

Check box in Interactive Reports

Posted: Sat Nov 20, 2021 4:29 am
by admin
-- A column to be added as below, so the user will check the lines and then in the process loop will insert values in a table.

select
ID,
apex_item.checkbox2(1,PROFILE_ID) as "Select",
name
from js_users

-- Process

begin

for i in 1..apex_application.g_f1.count
loop
apex_debug_message.log_message('Sikandar Hayat: ' || apex_application.g_f10(i));
insert into js_candidates (PROFILE_ID, comments)
values( apex_application.g_f1(i), :P24_COMMENTS);
end loop;
end;