ODC Appreciation Day : Timeline component in Oracle JET, Data Visualization Cloud, APEX and ADF DVT: #ThanksODC


Here is my entry for the Oracle Developer Community ODC Appreciation Day (#ThanksODC).

It is quite hard to make a choice for a feature to write about. So many to talk about. And almost every day another favorite of the month. Sliding time windows. The Oracle Developer Community – well, that is us. All developers working with Oracle technology, sharing experiences and ideas, helping each other with inspiration and solutions to challenges, making each other and ourselves better. Sharing fun and frustration, creativity and best practices, desires and results. Powered by OTN now kown as ODC. Where we can download virtually any software Oracle has to offer. And find resources – from articles and forum answers to documentation and sample code. This article is part of the community effort to show appreciation – to the community and to the Orace Developer Community (organization).

For fun, you could take a look at how the OTN site started – sometime in 2000 – using the WayBack machine: https://web.archive.org/web/20000511100612/http://otn.oracle.com:80/ 


And the WayBack machine is just one of many examples of timelines – presentation of data organized by date.image We all know how pictures say more than many words. And how tables of data are frequently to much less accessible to users than to the point visualizations. For some reason, data associated with moments in time have always had special interest for me. As do features that are about time – such as Flashback Query, 12c Temporal Database and SYSDATE (or better yet: SYSTIMESTAMP).

To present such time-based data in way that reveals the timeline and historical threat that resides in the data, we can make use of the Timeline component that is available in:

In JET:image


This image is described in the surrounding text

In Data Visualization Cloud:

Note that in all cases it does not take much more than a dataset with date (or date time) attribute and one or more attributes to create a label and perhaps to categorize. A simple select ename, job, hiredate from emp suffices.

About Author

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.


  1. Hi im new to apex 5.1 long time oracle user and hope to use sunburst, timeline and tag cloud. Sadly I can’t workout how to do it. Apex only shows options for simple charts, bar,line etc. How do you select and add a timeline to a region??

  2. Hammam Samir on

    Hello Mr. Lucas Jellema,
    I read a blog for you about Linking the Stacked Bar Chart to an ADF Data Table , it was several years a go,
    I’m asking if you have another blog on getting the Selected Slice Row Attribute of Pie Chart, I can’t find any resources about this issue at all ,and i got many errors when implementing that,

    Thank you

    • Lucas Jellema on

      Dear Hammam,

      I’m sorry but I cannot help you with your query. I do not have an example lying around and I am currently less focused on ADF so I do not have the opportunity to create a prototype for you.

      Best of luck,

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.