Apex 4.2 released with support for building Mobile App

http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html

Grouping visually in Interactive Report using jQuery

There will be sometimes a need arises to group the Interactive Report using the background color to visual identify the group of records.

So using jQuery in Interactive Report is one of the simplest solution.

Step 1: Create a Interactive Report
Step 2: Identify the Group Column
Step 3. Write a Dynamic Action which fires on refresh of the Interactive Report region. The Following code will do the job

var gcolor = '#dddddd';
var gprev_city = '';
var gcity ;

$("table.apexir_WORKSHEET_DATA > tbody > tr > td[headers='CITY']").each(function(){
    gcity = $(this).text();
        if (gprev_city != gcity) {
    if (gcolor == '#dddddd' )
        gcolor = '#6092D0';
    else
        gcolor = '#dddddd';
        gprev_city = gcity ;
    }
    $(this).parent().children().each(function(){
         $(this).css('background-color',gcolor);
    });
});

The Sample Application to demonstrate this feature is at http://apex.oracle.com/pls/apex/f?p=12278:2

apex.oracle.com is now running on Apex 4.2

The great news for Apex Developers is apex.oracle.com is upgraded to unreleased Apex 4.2 version which now supports building mobile apps for IOS devices and more mobile platforms.

Apex 4.1.1 is Released

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

Refreshing a Partial Page Refresh / Ajax based calendar Manually

Sometimes using Javascript code if you want to refresh just the Calendar region you ca use the javascript apex.widget.calendar.ajax_calendar('S','same') this will refresh the Calendar region, provided the Calendar is of type "Partial Page Refresh"/Ajax based.