Introduction This tutorial explains the steps to implement copy to clipboard feature in Oracle APEX using JavaScript for visible items. Steps Create a page item “P1_TEXT” Create a button “COPY” Create a dynamic action on click. Event: Click Selection Type: Button Button: COPY In the Tue Action select Execute JavaScript and execute below code. $("#P1_TEXT").select(); // Get and select the text field document.execCommand("copy"); // Execute copy command apex.message.showPageSuccess('Code copied to clipboard'); // Alert the user Example Reference https://developer.mozilla.org/en-US/docs/M ..read more

Introduction The default behavior of the left navigation menu is not user-friendly. The user has to click on “>” at the end of the menu item to expand or collapse it. This tutorial explains the use of JavaScript to expand/collapse the sub-menu in the left navigation pane in Oracle APEX. Before user has to click on the icon “>” to expand/collapse the menu.Steps Goto Global Page (Page 0) Create a dynamic action on page load Action : JavaScript and pase below given code snippet inside code. $("#t_TreeNav").on("treeviewactivatenode", function(e, ui) { var n$ = $(e.originalEvent.tar ..read more

Introduction   Interactive Report in Oracle APEX lets the user save public and private reports. Sometimes, it has to be deleted forever. However, the option is not available in the APEX page builder. This feature is hidden inside the page utilities. This tutorial explains the steps to delete the saved reports.   Saved reports in Interactive Report (Front-End)   Saved reports in APEX page builder (Back-End)   Steps   Goto App Builder –> Your Application –> Utilities –> Click on Saved Reports under Interactive Report Utilities.     Select the repor ..read more

Introduction This tutorial will help you understand the usage of apex.item javascript API to set the value of a page item. Syntax setValue(pValue, pDisplayValueopt, pSuppressChangeEventopt) Examples Input Field In this example, the value of the page item called P1_ITEM will be set to 10. As pSuppressChangeEvent has not been passed, the default behavior of the change event triggering for P1_ITEM will occur. apex.item( "P1_ITEM" ).setValue( "10" ); Pop-Up LOV In this example, P1_ITEM is a Popup LOV page item with distinct display and return values. The display value of P1 ..read more