After the “Oracle APEX round table talk with Mike Hichwa” I was asked an interesting question by another attending developer.
Is there a possibility to reset only the pagination of the detail report, when you have a master- and a detail report on the same page in an Oracle Application Express (APEX) application?
Did you ever have had the requirement that a validation should only fire if the page item has been rendered (eg. if you have defined a condition or authorization)?
As long as you set the “Associated Item” property in the validation to the page item you want to check, you are fine. Oracle Application Express (APEX) will do the check for you and only fire the validation if it’s there. BTW, I didn’t know that – really nice! 
But if you create a page level validation it’s up to you to determine if the item is there or not.
Some time ago I was asked if it’s possible to set the background color of the entries of a select list.
Sure why not! I thought I had already answered the question before, so I searched on the OTN forum but didn’t find my posting. No problem, shouldn’t be too hard to find the solution again.
That’s maybe an old tip and probably everybody already knows it, but because I just answered that question on the OraFAQ forum, I wanted to share it with you in case you didn’t know.
Maybe you have already noticed that in the Oracle APEX Builder at some pages a tooltip is used. For example for the icons on the Drag and Drop Layout page. This tooltip functionality can be reused in your own applications. You just have to add
onmouseover="toolTip_enable(event,this,'This is a tooltip')"
into the “Attributes” property of your HTML button or into the “HTML Form Element Attributes” property of your page item. In the end you can attach it to any HTML element. But I think you got the idea how it works.
The new HTML editor widget which was introduced in Oracle APEX 3.0 is a big enhancement compared to the old one in APEX 2.x and it works with all browsers.
The HTML editor is based on the open source editor FCKeditor. A few features have been removed, because they would require some server side code. One of them is to include images into the entered text.
But Carsten Czarski from the German APEX Community comes to our rescue!
Maybe you have already used a PPR (Partial Page Rendering) report, by setting the “Report Template” property to “template: 7. Standard (PPR)”.
That’s quite a nice feature, because not the hole page is rendered when you are paginating through the report, just the report itself is refreshed with an AJAX call. But what happens if you want to run some Javascript code after the report content has been refreshed? For example to hide the “Select All” checkbox of the row selector.
In the past few weeks there have been a few interesting APEX related postings I want to share with you.
Have fun reading them!
During the DOAG SIG workshop I was asked how to create a treeview in Oracle APEX where the current selected tree node is highlighted.
After a quick thought about the problem, it turned out that there is a quite simple solution for it if you combine the treeview query with some HTML code.
You want to create a button or a navigation list entry where you want to open an URL in a new browser window?
With plain HTML you would normally just write
<a href="http://url/" target="_blank">
but how to specify the target=”_blank” in Oracle APEX, where you just have the property “URL Target” which just allows you to enter the URL?
Today I read an article on Grant Rolands blog about sending a SMS from Oracle Forms through a Web-Service.
I thought it would be nice to have the same in APEX and PL/SQL, too. For example if you have a system failure or get a new order in your shop…