Application apex_item_checkbox in apex

Question

I have used a checkbox in intractive report, now i have a delete button also here.

i need to delete the records which user checked on checkbox.

my select query in intractive report is below.

select distinct
    a.GUID,
    a.CREATED_BY,
    a.created_date,
    apex_item.checkbox(1,b.DYNAMIC_GROUP_ID) Delete_Members
from NON_DYNAMIC_USER_GROUP_MEMBERS a,
    NON_DYNAMIC_USER_GROUPS b
where a.DYNAMIC_GROUP_ID in
    (select DYNAMIC_GROUP_ID
    from NON_DYNAMIC_USER_GROUPS
    where instr(','||DYNAMIC_GROUP_ID||',' , ','||:P153_ID_HIDDEN||',') > 0);

I need here to delete the records where the check box is checked.

Answer 1

I've created video some times ago which covers your problem. It's step by step tutorial how to create and process rows with checkboxes.

https://www.youtube.com/watch?v=T-LXRMWQbPk&feature=youtu.be

Regards