Oracle Tips by Burleson
Customizing a Calendar
from above does not contain much data on the page, and it does not
appear to offer much. However, if links are added to the page that
will navigate to a report where all the RSVPs for that date can be
seen, then it would be useful. This example will modify the calendar
attributes to add links.
Edit the calendar. If the page is still running, click on the
Edit Page 1135 link in the developer toolbar.
Click on the CAL link next to the Count of RSVPs by date
In the Column Link region, select URL for the Target and enter
the following into the URL Target and click Next.
The Column Link and Day Link operate as a
branch. It is possible to either branch to pages in the current
application or to a URL. The URL Target is being used to branch to
For this branch to work, the P11_RSVP_DATE
will have to be added to page 11 in the Conference RSVP application.
Then, the query on the report would be changed to add the following at
the end of the WHERE clause.
and ( rsvp_date = :P11_RSVP_DATE or
:P11_RSVP_DATE is null )
Attributes of the Calendar
A few of the other attributes that can be set on
the calendar are also located on the Calendar Attributes page.
There are three built in calendar templates from which to choose:
Calendar; Calendar Alternative; and Small Calendar.
Setting this to Custom will allow the Column Format to be treated
similarly to the HTML Expression attribute on reports. Using the
Custom display type, an image could be displayed in the calendar
column like this:
The above book excerpt is from:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty