Posts by chinnappa

How to Upload and Download Files using Object Storage Unit in Oracle Apex

Overview Object Storage unit is a high-performance storage platform. It is ideal for storing an unlimited amount of unstructured data.The files can be uploaded and downloaded using object storage unit…

Read More

How to Integrate Object Storage Unit in Oracle Apex Cloud

Overview Object Storage unit is a high-performance storage platform. It is ideal for storing an unlimited amount of unstructured data. Data is managed as objects using an API built on…

Read More

Adding Dialog Confirmation alert In Oracle Apex Using JavaScript

OverView This document talks about how to add a confirmation dialog alert in oracle apex using JavaScript.  We are going to add a confirmation dialog alert using apex.message.confirm() JavaScript method. Technologies…

Read More

Incremental Search for Report in Oracle Apex

Overview Incremental search is the search option, Using this option user will get the searching information as soon as the user starts typing in the input search field. To create this feature in the oracle apex we are going to create a text field item and interactive report. Also, We can create this using the classic report. Technologies and Tools Used The following technology has been used to achieve the expected output. JavaScript Use Case In oracle apex search option in the reports will work only when the user enters the enter key or…

Read More

How 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 More

How 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 More

Adding 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 More

How 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 More

How to Change Interactive Grid Rows Editable Based on The Condition

OverView This document talks about how to change editable in the interactive grid based on the condition. We can achieve this using a simple decode method. If the condition is…

Read More

Hide and Show in Oracle Apex Using JavaScript

OverView This document talks about how to hide and show the elements in oracle apex using JavaScript.By the following method, we can hide and show the oracle apex region, button,…

Read More