Print

IE Fix for Modal Region in Theme 25 appearing black

Written by Mandy. Posted in Templates & Themes.

This problem was detected in APEX Version 4.2.0.00.27

 

This issue occured when I developed an application usign Theme 25.

When viewing the Modal regions in IE8 (not sure about later versions), the page appeared like this:

transparency IE issue

 

This is a simple fix. You will need to add some css to each page that you are using the modal template on.

1) Edit the page

2) Edit the page definition (the top node in 'Page Rendering')

3) Scroll down to the CSS Section.

4) In the Inline area, add this css:

div#modalBackground {
-ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=40)" !important;
filter: alpha(opacity=40);
}
section.uModalRegion {
z-index: 1000;
}
section.modalOn {
display: block !important;
}

 

The page should now display correctly:

transparency IE issue fixed

 

 This solution was provided by Shakeeb. See the Forum post here: https://forums.oracle.com/forums/thread.jspa?messageID=10686196

Print

Displaying full path of hierarchical data structure

Written by Mandy. Posted in Useful Functions.

I have some data on one table that is heirerchical, i.e. there is a PARENT column that stores a number which is the unique ID of another record in the same table.

There is more than two levels, and for each record I need to display the full path - not just the immediate parent.

Every time I need to do this, I have to trawl through blogs/forums to get the syntax right.

About Me

I currently specialise in developing bespoke applications using Oracle APEX.I have worked with APEX since it was known as HTMLDB, but have also dabbled with E-Business Suite, Oracle AS Portal, ECM, Webcenter and Website Design.

I enjoy working with new clients and assisting them develop custom applications to enhance and improve internal business processes.

Find Me

mandy nerd2