Search
  • Bheem

Key board shortcuts in oracle apex Interactive grid.

How to implement keyboard shortcuts in oracle apex interactive grid.

1. To Add Row -- ALT+A

2. To Delete Row -- ALT+D

3. To Set Focus to Search -- ALT+F

4. To reset -- ALT+C

5. To Save the data -- ALT+S


JavaScript Code:

function( options ) {
    //Tab and Shift-Tab will skip over cells that are read-only
    options.defaultGridViewOptions = {  
        skipReadonlyCells: true  
    };  
    
    options.initActions = function( actions ) {                
        //Action to focus on the Search Bar
        actions.add( {
            name: "focus",
            label: "focus",
            action: function( event, focusElement ) {
               var ig$ = $(actions.context);
               ig$.interactiveGrid("focus");
               return true;               
            }
        });
        
        // Add a keyboard shortcut to Add a Row
        actions.lookup( "row-add-row" ).shortcut = "Alt+A";
        actions.update( "row-add-row" );
        
        // Add a keyboard shortcut to Delete a Row
        actions.lookup( "row-delete" ).shortcut = "Alt+D";
        actions.update( "row-delete" );      
        
        // Add a keyboard shortcut to Save the changes
        actions.lookup( "save" ).shortcut = "Alt+S";
        actions.update( "save" );          
        
        // Add a keyboard shortcut to refresh the IG
        actions.lookup( "refresh" ).shortcut = "Alt+R";
        actions.update( "refresh" );   
        
        // Add a keyboard shortcut to focus on the Search Bar
        actions.lookup( "focus" ).shortcut = "Alt+F";
        actions.update( "focus" );    
        
        // Add a keyboard shortcut to reset the IG
        actions.lookup( "reset-report" ).shortcut = "Alt+C";
        actions.update( "reset-report" );                  

        }        
    return options;
}

207 views0 comments

Recent Posts

See All

How to create network ACL in oracle database.

when you are calling third party API in oracle using UTL_HTTP then you will face Network access denied by ACL error if ACL is not created. To create ACLfirst login with sys account then run below code