Apex.server.process
Description: This function calls a PL/SQL on-demand process defined on page or application level. It’s a wrapper of the jQuery.ajax function and supports all the setting the jQuery function provides but…
Read MoreRole based Authorization in Oracle APEX5
Description: To implement Role-based Authorization in Oracle APEX Application, in version 5. Application Item: USER_ROLE Table: ROLE_ACCESS_CONTROL The purpose of this table is to store the privileges on Regions, Buttons, and Items for…
Read MoreProgress Bar in Reports in APEX5
Description: APEX can create “Percentage Bars” within a report. This can be achieved using HTML Code in your Report SQL Query. Steps: 1- Create your report: Create an Interactive or Classic Report using SQL query : SELECT CASE WHEN COLUMN <= 30 THEN ‘<div class=”a-Report-percentChart” style=”background-color:#000000;width:100%;”><div class=”a-Report-percentChart-fill” style=”width:’ || COLUMN || ‘% ; background-color: 330099;”></div><span class=”u-VisuallyHidden”>’ || COLUMN || ‘</span></div>’ || COLUMN || ‘%’ WHEN COLUMN BETWEEN 30 AND 50…
Read MoreSearch on Double Click in IR Report
Description: If double-clicking for Adhoc operations are enabled to IR report in the following steps. Place the below code in HTML Header: <script type=”text/javascript”> $(function(){ $(‘.apexir_WORKSHEET_DATA td’).live(‘dblclick’,function(){ $(‘#apexir_SEARCH’).val($(this).text()); gReport.search(‘SEARCH’); }); }); </script> Summary: The HTML header to enable…
Read MoreMultiple selection in select list item – Oracle Apex 4.2
Description: To select multiple values from select list item in Oracle Application Express 4.2. Step 1: Create Select list item. Step 2: Step 3: Output: Summary: The screenshot showed that multiple values from the select…
Read MoreHow to set background in Oracle Apex 5 application using CSS
Description: To set background in Oracle Apex 5 application using CSS (Cascading Style Sheets). Step 1: Create a HTML Region. Step 2: Put a required image into Shared Components. Step 3: In this region, source CSS can be added for setting background. Output: Summary: To set up the background covering image in oracle with the help…
Read MoreSLIDESHOW OF IMAGES IN APEX
Description: Websites that include many images, such as art or photo gallery sites, can benefit by presenting some (or all) of their images in slide show format. Slideshow of various Images on an Apex Page can be achieved using HTML, JavaScript, CSS, and jQuery. Step 1: Uploading all the images in the Workspace Shared ComponentsàFilesàImagesàCreateàSelect Application nameàChoose image fileàUpload. Step 2: Source code Give the following code in the Page Region source. Make sure that all the images are uploaded in the Workspace. Source Code: <div id=”slideshow”> //opening the Slider division…
Read MoreNotification Message Bar design change in Oracle APEX 4.2 using CSS
Description: To change the “Notification Message Bar” design throughout the Oracle Application Express 4.2 application. Requirement: The customer has asked us to change the default “Notification Message Bar,” because it…
Read MoreShrinking of Navigation Menu on page load
Requirement: Navigation menu should be shrinking on page load. Challenges faced: In Oracle Apex 5, universal theme the navigation menu is strengthening on default page load. If we want to shrink the menu we need to click on the navigation menu controller. Resolution: Created a dynamic action with event as page load and condition as JavaScript Expression and value as $(‘#t_Button_navControl’).attr(‘aria-expanded’) === “true”. A true action is provided with JavaScript code as $(‘#t_Button_navControl’).click(); Output:
Read MoreSearch bar for Tabular form with auto complete option for Date values
Description:The search button in tabular form is helpful to identify the exact data in the tabular form, that will act like a filter in interactive report shows the particular values…
Read More