Oracle APEX
allows you to add calendars to your application with monthly, weekly, daily,
and list views. Calendar is based on the FullCalendar jQuery library and can
only be customized through CSS. You can create a calendar based on a table or SQL query. During the creation process, you are
prompted to select date and display columns. Once you specify the table on
which the calendar is based, you can create drill-down links to information
stored in specific columns and enable drag and drop capability.
Using the
Calendar component you can:
- Display calendar events on multiple views (Month, Week, Day, or List).
- Render duration and non-duration based events.
- Render events from external sources using web service calls or Google Calendar feeds.
- Modify the start and end dates by dragging and dropping events on different dates. Drag and drop is only supported for local data sources, that is, database objects in the referenced database schema and not on external data sources such as a Google calendar.
- Edit or add new events on calendar using forms by clicking either on events or empty calendar cell.
- Use different CSS classes, developer can choose different styles for different types of events.
- Share events using multiple formats (iCal, CSV, XML).
- Enable tooltip to make it easier for users to have a quick look at details of each event.
To use the
calendar,
you need to prepare a SQL query with the following columns:
Start Date – the start date
for events displayed on a calendar. It can include the starting
time.
End Date – the column which
holds the end date for events displayed on a calendar. If this attribute is
specified, then the calendar displays duration based events.
Display – Holds the text
displayed for events on a calendar.
CSS Class
– the CSS class name to style the events displayed on a calendar. This column is optional.
Primary Key – primary key for
the event. The column becomes necessary if you want to enable drag and drop
feature.
Supplemental Information – additional
information which is displayed in the List View and Tooltip. Use &COLUMN.
syntax to show column values in HTML. Show Tooltip must be set to
Yes in order for this supplemental information to be displayed in the Month,
Week and Day views.
Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:13
