Display Time in Navigation Bar
1. Overview This document explains how to create a Display Time in Navigation Bar using Oracle APEX. 2. Technologies and Tools Used The following technologies has been used to achieve…
Read MoreTable Alter Script by comparing 2 schema
Table of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates alter scripts…
Read MoreHow to set the interactive grid column values to the page item
Overview This document talks about how set the interactive grid column values to the page item.this is achieved using JavaScript. Technologies and Tools Used The following technologies has been used to achieve the expected output. JavaScript Use Case Assume that we are having the interactive grid report. We want to do some operation based on the values on the interactive grid column then,we can use this method to achieve the same. This document explains how to achieve this requirement. Architecture Following steps explains in detail, Step 1: We needs to add the static ID to the interactive grid region. Step 2: We needs to create dynamic action on the Lose Focus event ,selection type as region and region as the which region you want to take the column values. True action of the dynamic action is execute JavaScript.we needs to add the below JavaScript to execute JavaScript region . var data=””; var model = apex.region(“IG_REGION”).widget().interactiveGrid(“getViews”, “grid”).model; model.forEach(function(igrow) { //ENAME will be column name which you want to get values var test =igrow[model.getFieldKey(“ENAME”)]; //For some version above will not work for that use the below code // var test =igrow[model.getFieldKey(“ENAME”)].d; //here d is display value ,even we can use return value r also.…
Read MoreHow to remove the interactive grid default alert for unsaved changes
Overview This document talks about how to remove the interactive grid default alert for unsaved changes.we are going to achieve this requirement using JavaScript. Technologies and Tools Used The following technologies has been used to achieve the expected output. JavaScript Use Case Assume that we are having form region and interactive grid region on the same page.We are having the same save button for the both region.In this scenario ,If we write the on change event for refresh of the interactive grid region. This will throw error for unsaved changes and the selected values in the form region will get clear. To over come this we are going for the JavaScript. This document explains how to achieve this requirement. Architecture Following steps explains in detail, Step 1: We needs to add the static ID to the interactive grid region. Step 2: In the change event of the button or item, we have to add the dynamic action to execute JavaScript and we needs to add the below code. apex.region(‘IG_REGION’).widget().interactiveGrid(‘getViews’, ‘grid’).model.clearChanges(); apex.region(“IG_REGION”).refresh(); Screen Shot Output: Using the above step we can remove the unsaved changes alert of the interactive grid.
Read MoreAdding Customized Background Color to the Interactive Report Cell
Overview In this document, we are going to see about how to add customized background color in report cell of interactive Report.This is achieved using CSS and JavaScript.Also,Different method to…
Read MoreExcel Template in oracle Apex for Excel Upload Page using JavaScript and Oracle pl/sql
Objective: The Excel Upload Page in Oracle Apex Involves Excel Upload template design. Usually the templates will be stored in Shared Components Workspace File and through button click JavaScript call,…
Read MoreHow to Prevent Dialog Page Close By Disable Escape Key and Hide Close Button
Overview In this document, we are going to see about the prevention of dialog Page close by disabling the escape key and hide the close button. Technologies and Tools…
Read MoreInteractive Grid Toolbar Customization -Part 2
Overview Interactive Grid (IG) allows a great deal of customization to its toolbar and menus. The toolbar is implemented by a new toolbar widget. Like most widgets, the toolbar is…
Read MoreInteractive Grid Toolbar Customization Part 1
Overview Interactive Grid (IG) allows a great deal of customization to its toolbar and menus. The toolbar is implemented by a new toolbar widget. Like most widgets, the toolbar…
Read MoreRegional Display Selector Freezing In Oracle Apex
Regional Display Selector Freezing In Oracle Apex The Region Display Selector is a Region component that provides page-level navigation control for other regions with the Region Display Selector property set to Yes. It can be configured to work in two modes: View Single RegionShow regions as tabs. Selecting a tab will make the corresponding region visible and hide the other selections. Scroll WindowAlways display all the regions on the page. Selecting a tab will scroll your window to the corresponding region. Technologies and Tools Used…
Read More