Check box in Interactive Reports
Posted: Sat Nov 20, 2021 4:29 am
-- 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;
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;