HOW TO CHECK ALL CHECKBOX IN IN INTERACTIVE GRID ORACLE APEX?



1. Set static ID in IG

2. create one item supposed P5_CHECKBOX_ALL 

VALUES: 1 FOR CHECKED,0 FOR UNCHECKED


3. use Dynamic action on P5_CHECKBOX_ALL 

and use below code

// Get the Interactive Grid widget instance

var ig$ = apex.region("roles_assign").widget();

var model = ig$.interactiveGrid("getViews", "grid").model

// Loop through all records in the interactive grid

model.forEach(function(record) {

 // Access the column value and update it

 var newValue = 1; // Specify the new value here

 var val = apex.item('P5_CHECK_ALL').getValue();


 model.setValue(record,'ADDING', val);

 model.setValue(record,'DELETING', val);

 model.setValue(record,'UPDATING', val);

  

});


















Comments

Post a Comment

Popular posts from this blog

 HOW TO CREATE API AND VIEWS FROM ORACLE APEX COLLECTION? Using the following codes to generate Package and package specification, body and view and trigger  /* INSTALL INSTRUCTIONS In the target schema: - create package spec and package body (apex_collections_dml_pkg) - create view (APEX_COLLECTIONS_DML) - create instead of trigger (APEX_COLLECTIONS_DML_TRG) Actually, You can simply execute the following script */ CREATE OR REPLACE PACKAGE apex_collections_dml_pkg AS TYPE t_coll IS TABLE OF apex_collections%ROWTYPE; FUNCTION get_coll_data RETURN t_coll PIPELINED; END apex_collections_dml_pkg; / CREATE OR REPLACE PACKAGE BODY apex_collections_dml_pkg AS FUNCTION get_coll_data RETURN t_coll PIPELINED IS     CURSOR c_data IS         SELECT *         FROM apex_collections;     lrData t_coll; BEGIN     OPEN c_data;          LOOP         FETCH c_data BULK COLLECT INTO ...
Read more
Image
 how to Remove success message in oracle apex 20.1 20.2 and any lower versions? step no 1:go to dynamic actions and make one dynamic action on page load like the following figure 01  step no 2: make true action and set action execute javascript code step no 3: Write the following function in setting code setTimeout(function(){  $('#APEX_SUCCESS_MESSAGE').fadeOut('fast'); },3000) and save it it will remove success message when any submit buttons are clicked  Subscribe our channel in youtube :Najeeb Alikel  https://www.youtube.com/results?search_query=najeeb+alikhel
Read more
Image
 how to use dynamic action hide and show in oracle apex 20.1 version? step 1: Create two regions one for single item select list  and second for emp report  as the following  the first region should be static content and with one item  p3_select_list and lOV Static  values: show and hide second region is report  interactive report  sql query: select * from employees; dynamic action is on click and true action is: false action: this is a final output    najeebalikhel@gmail.com youtube channel : Najeeb Alikhel subscribe our channel for videos  https://www.youtube.com/results?search_query=najeeb+alikhel
Read more