Posts

Partial Page Refresh ($a_report) and jQuery 1.3 new methods LIVE/DIE

If you are using "Partial Page Refresh" to navigate through the pages of a report, the new methods live and die should be useful. The "Partial Page Refresh" functionality uses the JavaScript function $a_report to request the report's body and then refresh the report without refreshing the whole page (AJAX). Before, we were able to bind a click event to DOM elements. The click event was not propagating itself to new DOM elements created dynamically after the bind action. For example: if you bind the click event to every rows of your report, you have to bind the click event to new rows generated after calling the function $a_report. Now, we are able to bind a live event to our DOM elements. The click event is now able to propagate itself to new DOM elements created dynamically after the bind action. You can try a working example of jQuery Event Live in APEX . Happy Web 2.0 coding! :)

jQuery 1.3 - new release

Good news everyone! A new release of jQuery saw the day. Find more information about jQuery 1.3 on the official website. The major new features are: * Sizzle: A sizzlin’ hot CSS selector engine. * Live Events: Event delegation with a jQuery twist. * jQuery Event Overhaul: Completely rewired to simplify event handling. * HTML Injection Rewrite: Lightning-fast HTML appending. * Offset Rewrite: Super-quick position calculation. * No More Browser Sniffing: Using feature detection to help jQuery last for many more years to come. For more information, read the jQuery 1.3 release documentation . I'll try to do demos showing the new features in the upcoming days... Happy coding!

Generate a "tag cloud" using DynaCloud (jQuery Plugin)

To make your application look more Web 2.0, it's a good idea to add a Tag Cloud section on some pages. ;) I did a little search for a jQuery plugin that can do the job and I found DynaCloud . You can include a Tag Cloud on your page in 4 steps. 1) Add on your page a container for the tag cloud. For good results create an HTML Region and put the following code in the region source. (Set the template to Sidebar Region) <div id="dynacloud" style="font-size:12px;"></div> 2) Load jQuery using Google AJAX Libraries API <script src="http://www.google.com/jsapi"></script> <script> // Load jQuery google.load("jquery", "1.2.6", {uncompressed:false}); </script> 3) Load DynaCloud Plugin <script src="&WORKSPACE_IMAGES.jquery.dynacloud-4.js"></script> 4) Add CSS styles to display the Tag Cloud <style type="text/css"> div#dynacloud { font-size:5px...

Google AJAX Feed API

Image
I'll start the year by showing you how to add a simple feed reader to your page. For my demo, I decided to use the feed from the "official" Apex Blog Aggregator . Using Google AJAX Feed API , you can easily load and parse feeds. Using Google Visualization API , you can easily display the information in a datagrid. For more information, consult my online demo of the Google AJAX Feed API in Oracle APEX .

Happy New Year

Dear APEX Community, I want to wish you a Happy New Year. For 2009, I wish you many many many APEX projects. 2009 will be full of APEX demos and tutorials! :D Take care

Using "Prompt LOV" to replace "Popup Key LOV"

Another post about jQuery in APEX! :) I am really happy to see the interest the APEX Community has for jQuery. After reading Dan McGhan's blog post concerning jQuery Impromptu , I decided to try this jQuery extension. For my demo, I decided to replace a "Popup Key LOV (Displays description, returns key value)" with a "Prompt LOV". I was able to reuse code from previous demos to accelerate the development. Here is a working example of the Prompt LOV & Calendar demo . How does it works? 1) I assume you check and understand these demos: A) Popup in Report B) AJAX request Page Report C) jQuery Datepicker Now... we can continue to the next step. :) 2) Replace the existing Popup LOV with a Prompt. The prompt will display a report from another page(in this case, it's the page 42). The report is requested using AJAX. This is the JavaScript code you need: $().ready(function() { //Replace existing POPUP-LOV $("#P41_DEPTNO_fieldset a") .attr(...

how to build a Google Gadget with data fetched from an APEX Application Process

Last week, I release a Google Gadget to publish the weekly release of Insum's Web 2.0 Demos . I'll explain how I did it. Google Gadget... what's that?! It's an XML file defining every aspect of your gadget(module) . The words "gadget" and "module" can both be used to describe a Google Gadget. The gadget definition contains 3 sections: 1)Module Preferences The general information of my gadget is defined in this section. Here is the list of attributes for which I set values. title title_url description author author_email author_location author_affiliation author_link author_photo author_quote height width I put a default value for the height. Users can update this value using the gadget's settings (build using the "users preferences"). It's also possible to auto-adjust the gadget height. 2)Users Preferences The settings of my gadget are defined in this section. Here's the list of settings available to the users. itemCount fHeigh...