Oracle Apex Notebook

Reset region pagination via URL

Written by Paulo Vale on Monday, January 28, 2008

As you probably know :) you can create links between pages in your application using the following syntax:

f?p=App:Page:Session:Request:Debug:ClearCache:itemNames: itemValues:PrinterFriendly

The ClearCache argument sets the value of items to null. Here you can specify items, pages or even entire application to clear the cached value. There is another thing you can do: the keyword RP resets region pagination on the requested page.

Javascript Tooltip Integration

Written by Paulo Vale on Tuesday, January 08, 2008

As I've said in my previous post, there is another interesting project for handling tooltips, the BoxOver Tooltips from the same author of the calendar script.





It is a small javascript that you can integrate with you APEX applications. It is very simple to use and has powerful customizations possibilities like using your own CSS to change the look and feel. You can even include pictures in your tooltips. Go to the project page for nice examples and howtos. Click here to see it working with APEX.



To install the script, download the latest version of BoxOver tooltips and copy the boxover.js script into a filesystem directory or just upload it as a static file under Shared Components. Include the following somewhere in the HTML of your page (Header section of you page or directely in page template if you want the tooltip feature available in all application pages). Substitute the path of the file accordingly making sure it points to the correct location of the boxover.js file.





Now you can use this feature just by calling it in an appropriated place. A simple example, using a Text Field is adding the following tag to "HTML Form Element Attributes" property :

TITLE="header=[Date] body=[Click here to pick a date]";

BoxOver is configured through the "title" attribute of HTML elements. This means you can use it in all your HTML objects. Works in all latest browsers incl. IE 6, IE 5, Mozilla 1.4+, FireFox 0.9.3 Opera 7.

Javascript Calendar Integration

Written by Paulo Vale on Monday, January 07, 2008

One of the good things about APEX is that we're not limited to the buit-in features. There are hundreds of examples of free code you can find with the help of Mr. Google :)

Today I'll show one of these examples. A small javascript calendar that you can integrate in you APEX applications. Click here to see it working.

I've found this simple but great small javascript calendar at http://calendar.swazz.org/ . Click here to download the latest version.

To install the script:

1- Copy the calendar.js script into a filesystem directory or just upload it as a static file under Shared Components.

2- Include the following somewhere in the HTML of your page (Header section of you page or directely in page template if you want the calendar available in all application pages). Substitute the path of the file accordingly making sure it points to the correct location of the calendar.js file.



3. Create a Text Item in your page and open the item properties page. Add to the the code:

onfocus="this.select();lcs(this)"
onclick="event.cancelBubble=true;this.select();lcs(this)"

4. Run the page and click the Text Item.

There is another interesting project for tooltips from the same author of the calendar script. If I manage some free time i'll blog about it later.