Css – Two Chart regions need to be same size
I have a page with 3 main charts, two in the same line (like the image) the first 2 are different in height, how to fix the height to be the same one chart is pie and the another one…
Html – Conditionally display/hide universal icon in inline help text in APEX
I'm working with APEX ORACLE ver 23.1. My problem is to conditionally display or hide fa-warning in inline help text of one page item (P1_item1). The condition is based on another page item: display if P1_item2 <> '' hide if…
Generating deep nested JSON palyload out of Oracle SQL
I have a need to generate a three level nested JSON payload out of Oracle tables. I have described two approaches I have used to accomplish this and neither of them work. Please advise where am I going wrong! Approach…
oracle apex, adding image to email template html body
`<div class="row" style="display: flex;"> <div style="flex: 33.33%; padding: 5px;" class="column"> <img src="#APP_FILES#icons/hololo.png" alt="Snow" style="width:50%"> </div> <div style="flex: 33.33%; padding: 5px;" class="column"> <img src="https://i.hizliresim.com/mxyxumi.png" alt="Forest" style="width:50%"> </div> </div> this is my email template body, i want to add image from app…
Javascript – Conditionally Formatting Cells in APEX IG
I'm currently trying to conditionally format individual cells for an IG inside of an Oracle Apex application. To accomplish this I added the following JavaScript function to the "Function and Global Variable Declaration" section of the page settings: function highlight_ig_cells()…
How can Jquery run code when user selects a value or leaves a text field with auto complete?
I am using APEX 22.2.4. I need to run some code whenever user selects a value from the lov's data displayed when user starts to enter some letters in the field or when they leave the field without picking up…
Can Pl/SQL in Oracle Apex on Centos create a Canonical String from a JSON Format?
I am using Oracle Apex 22.2 and Oracle Database XE 21c on CentOS 7. I want to loop through all the nested elements in a JSON document/CLOB and achieve the Canonical String (shown below). Also, any suggestions on improving my…
Can Javascript be used to create card functionality in Oracle Apex?
HI ALL, I want to achieve this functionality. when I click ADD on the item, the item is automatically added to the apex_collection. How to achieve this in oracle apex I have tried classic report with cards template but got…
Javascript – Oracle Apex dynamically change success message color based on page item
I'm using oracle apex version 22.2 and I'm trying to conditionally change the color of my pl/sql's success message based on a page item value. Basically if my process returns a '1' into my page item then I want the…
Twitter bootstrap – How to created a dynamic list on Apex 4.2?
I am currently trying to create a Dynamic List on Oracle Apex 4.2 with an overlay of the twitter-bootstrap. I am trying to use the chat functionality, and in order to do that I would need to use an object…