NajeebKhanOrclApex

 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);    });

 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 ...

How to add shortcut Key in oracle apex Interactive Grid?  Action Description Customized Shortcut row-add-row Insert a row straight after the current row Alt + A row-delete Delete the current row Alt + D save Save the current data changes. Note: Interactive Grid must be editable Alt + S refresh Refresh the Interactive Grid region Alt + R reset-report Reset the current report settings Alt + C focus Focus on Interactive Grid's Search Bar. This action is not included in the widget. Alt + F Follow the following steps: Using this code in Interactive Grid Attributes and JavaScript initializations function( options ) {     //Tab and Shift-Tab will skip over cells that are read-only     options.defaultGridViewOptions = {           skipReadonlyCells: true       };            options.initActions = function( actions ) {                   ...