 |
|
ss
Oracle Tips by Burleson |
Customizing a Calendar
The 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.
1.
Edit the calendar. If the page is still running, click on the
Edit Page 1135 link in the developer toolbar.
2.
Click on the CAL link next to the Count of RSVPs by date
region.
3.
In the Column Link region, select URL for the Target and enter
the following into the URL Target and click Next.
f?p=102:11:&SESSION.:::11:P11_RSVP_DATE:#RSVP_DATE#
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
another application.
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 )
Other Customizable
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:
<img src="#IMAGE_PREFIX#24find.gif"
/>
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|
