Interactive Report All Select

Interactive Report All Select||Multiple Approval in Oracle Apex

Topic Introduction: In this tutorial, we want to show how to mark or select multiple rows for any working purpose. Suppose we want to approve by selecting multiple rows at a time on Oracle Apex in this case we can use this tutorial for this kind of task. Here is SQL Query for Check Item, Dynamic Action for select rows, and Process to update status or any other data of selected rows.

Interactive report Query:

SELECT APEX_ITEM.CHECKBOX2(1,ID) AS "SELECT",

HR_REC_CIRCULAR_ID,

CANDIDATE_NAME,

CANDIDATE_NID,

CANDIDATE_PHONE

FROM HR_REC_APPLICATION 

Interactive report Region Static ID: allSelectSyncrep

"SELECT" column Heading:<input type="checkbox" id="allSelectSync">

"SELECT" column Properties Enable User To All Inactive

Dynamic Action All Select:

Event: Change

Selection type: jQuery Selector

jQuery Selector: #allSelectSync

Action: Execute JavaScript Code

if ($('#allSelectSyncrep #allSelectSync ' ).is(':checked') ) {

  $('#allSelectSyncrep input[type=checkbox][name=f01]').prop('checked',true);

} else {

  $('#allSelectSyncrep input[type=checkbox][name=f01]').prop('checked',false);

}

Process For Approval: 

FOR i in 1..APEX_APPLICATION.G_F01.COUNT LOOP

UPDATE HR_REC_APPLICATION

SET SLIST_STATUS= 'Y',

SLIST_BY = :APP_USER,

SLIST_ON= SYSDATE,

SLIST_COMMENTS= NULL

WHERE ID= to_number(APEX_APPLICATION.G_F01(i));

END LOOP;