Oracle Apex Notebook

Oracle Application Express 3.1 Evaluation

Written by Paulo Vale on Thursday, November 22, 2007

Apex Team made available today the Oracle Application Express 3.1 Evaluation. Registrations are available here.

I've finished my request for a workspace minutes ago. Can't wait to put my hands in the new Interactive Report Regions. I hope they didn't forget to include a functionality to generate charts using this report regions.

Populate date field using javascript

Written by Paulo Vale on Thursday, November 15, 2007

In some date fields it's useful to have a quick link to populate with, for instance, todays date. See it here.

To accomplish that, first you can attach this javascript code to you page template.

<script type="text/javascript"><br /> function setTodayDate(id, offset) {<br /> // dd/mm/yyyy<br /> var date = new Date();<br /> if(offset!==undefined)<br /> date.setSeconds(date.getSeconds()+offset);<br /> var year = date.getFullYear();<br /> var month = date.getMonth();<br /> var day = date.getDate();<br /> var obj = document.getElementById(id);<br /> if(obj)<br /> obj.value = day+'/'+month+'/'+year;<br /> }<br /></script>
Then you just need to add html code to call the function. The best place to put the code is in my opinion, the "Post element text" region of the field.

<a href="#" onclick="setTodayDate('P1_DATE_ITEM');">Today</a><br /><a href="#" onclick="setTodayDate('P1_DATE_ITEM', <br />7*24*60*60 );">7 Days</a>
Now you can play around changing the date format and adding entries to days, weeks or months.

Check all checkboxes

Written by Paulo Vale on Wednesday, November 14, 2007

There is a nice site with lot of useful examples of apex javascript built in functions.

Specifically here you can find a simple example to check all checkboxes at once.

A nice way to integrate this in APEX is to create a checkbox item based on a list of values and in the "Post Element Text" have something like:

<a href="#" onClick="html_CheckAll('P22_MULTI',true);">All</a>
<a href="#" onClick="html_CheckAll('P22_MULTI',false);">None</a>

This will create two links. One to check all checkboxes and other to uncheck them all.

Enlarge shuttle item

Written by Paulo Vale on Friday, November 02, 2007

If you think the shuttle item doesn't have enough with then do the following.

Within the shuttle item, look for the property "HTML Form Element Attributes" and enter the following against it:

HTML Form Element Attributes: style="width:250px"

This should solve your problem.

I got this tip from Tony Fatouros in Oracle Apex Forum.

Wizard Progress List without the "Start" entry

Written by Paulo Vale on Friday, November 02, 2007

Some templates in APEX adds a "Start" entry in the Wizard Progress List.

For people like me who develops applications in other language than English (in my case Portuguese) this is not good.

Like other things in APEX this "issue" is simple to resolve. Just go to Edit List Template. Then remove from the "Before List Entry" region the html code:

<div class="noncurrent"> Start</div>

And it's done!