ODTUG Kaleidoscope 2011

Last week I returned to the Netherlands after a very strict travel schedule from Kaleidoscope 2011. Delays, heavy turbulence, running at airports and hoping to see my luggage back, made my trip back not that pleasant. Next time a direct flight to Los Angeles?

It was a week packed with sessions. For me the accent was of course on APEX. Within every slot 3 sessions to choose from, it was an intense week. Sunday was reserved for Oracle's development team. Lots of info on APEX 4.1. One of the best sessions for me that week was the session 'APEX 4 + HTML 5 = Awesome' by Martin Giffy d'Souza. Always nice to see that in various presentations 'our' APEX plugin site came along.

Always nice to catch up with all APEX minded people. With my ACE friends we had a excellent ACE dinner at a very good restaurant. The highlight of the week was the big party at the Queen Mary.

I'll hope to see everyone again in San Antonio at Kaleidoscope 2012!

Oracle APEX 4.1 Early Adopter Release 1 available

Oracle APEX 4.1 Early Adopter Release 1 is available on tryapexnow.com. One of the greatest improvements is the error handling. Since 2004 I waited for this enhancement. For Mobile Support and Data Upload we have to wait a little more.

A description of all new features is here.

Happy testing!

Highlight current record in Interactive Report

- Create an interactive report with an ID column. On the page must be an item (Pxx_ID which holds the ID, for example an item in a form region to edit the details of a selected record, based on the same table on the same page.

- Don't define a link in the reports attribute page, but do it at the ID column. The reason is that you can't use the #ID# syntax in the link icon property.

- At the property of the link icon of the column with the ID, define the image tag with an additional attribute:  value="#ID#". When the user clicks on the link, the value of the ID must be stored in the previously defined id-item. Also define the rest of the brach logic when a user clicks on the link. 

At page level include in the 'Execute when Page Loads' property, the following jQuery javascript:

$('img[value=' + $v('Pxx_ID') +']').parents('tr:first').children('td').css('background-color','#CCFFFF');