Oracle APEX Region Plugin - Timeline

Timeline is a region type plugin that allows you to draft very nice looking timelines with a single sql query. It is based on JS Framework timeline.js (https://github.com/NUKnightLab/TimelineJS).

You can embed various sorts of media via URLs, for example:

simple Images
Videos
Music
Youtube
Flickr
Twitter
Google Maps
and many more, read more on timeline.js homepage.

Changelog

1.1 - fixed broken timeline when optional columns from sql source were null / fixed broken timeline when headline or description contains special character returns / fixed display of apex substitution strings in sql source and plugin attributes / enhancement: added possibility to display timeline slider only instead of timeline + media content

1.0 - Initial Release

Install

Import plugin file "region_type_plugin_de_danielh_timeline.sql" from source directory into your application
(Optional) Deploy the CSS/JS files from "server" directory on your webserver and change the "File Prefix" to webservers folder.

Plugin Settings

The plugin settings are highly customizable and you can change:

Headline of master page
Description of master page
Media URL of master page
Choose between 17 fonts
Choose between 60 languages, just enter the language code
set the default width(pixel and percent) and height(only pixel)
All the rest comes out of your sql query.

Example SQL Query:

SELECT start_date (date),
       end_date (date),
       headline (varchar2),
       description (varchar2 - nullable),
       media_url (varchar2 - nullable)
  FROM timeline

Demo Application

https://apex.oracle.com/pls/apex/f?p=APEXPLUGIN

Preview

At the moment only whole days are supported. Support for hours is planned for future releases.

Dani3lSun/apex-plugin-timeline