What are calendars?

Definition

Calendars display data from database tables or views as bar charts. The following section of an example calendar displays employee names from the SCOTT.EMP table on the day the employee was hired.

Sample calendar

Writing a SQL query for a calendar

Calendars display data according to dates you specify using the SQL query. The format for a calendar query is:

SELECT

the_date,

the_name,

the_intermedia,

the_name_link,

the_date_link,

the_target

from schema.object

where:

the_date (required)

Displays text on the calendar on the dates contained in this table or view column.
Values in this column must have the DATE datatype.

the_name (required)

Displays cell text from this table or view column according to the dates in the_date column.

the_intermedia (optional)

Displays interMedia-type cell data.

the_name_link (optional)

Specifies a link from the values in the_name to another OracleAS Portal database portlet or URL.
If you do not want to display links from calendar names, specify null for this column.

the_date_link (optional)

Specifies a link from the values in the_date column to another OracleAS Portal database portlet or URL.
If you don't want to display links from calendar dates, specify null for this column.

the_target_frame (optional)

Specifies the URL of a frame in a web page. Specify this column if you want to link to a specific frame in a URL.
If you don't want to link to a target frame, specify null for this column.

Adding links

You can add hypertext links from values within the calendar to other OracleAS database portlets, database portlet customization form, or a URL.

Syntax for named link specification:

<portal schema name>.wwv_user_utilities.get_url(
'<app name>.<link name>',
'<link parameter name 1>', <link parameter value 1>,
'<link parameter name 2>', <link parameter value 2>,
...
'<link parameter name n>', <link parameter value n>)

Notes

The maximum value for n is 30.
<link parameter name> is the parameter name of the link target database portlet.
If the <link parameter value> is static, it must be quoted; if the <link parameter value> is from a column, specify the column name.

The following example provides the SQL SELECT statement for a calendar that links to a form. The example assumes that a link (LINK_TO_FORM) has been created that links to a form based on SCOTT.EMP.

select
EMP.HIREDATE the_date,
EMP.ENAME the_name,
null the_intermedia,
portal30.wwv_user_utilities.get_url(
'APP_1.LINK_TO_FORM',
'empno', EMPNO,
'_empno_cond', '=') the_name_link,
null the_date_link,
null the_target
from SCOTT.EMP
order by EMP.HIREDATE

The following example provides the SQL query to use a link that has been built based on a URL:

select
EMP.HIREDATE the_date,
EMP.ENAME the_name,
null the_intermedia,
'http://www.oracle.com' the_name_link,
null the_date_link,
null the_target
from SCOTT.EMP
order by EMP.HIREDATE

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.