Skip to Main Content

Overview

Timeline is a Classic Report template that is useful for displaying a series of events. It can be used to showcase the history of a given widget, recent updates, or new interactions within an application.

Instructions

  1. In Page Designer, select a region
  2. Go to the Property Editor
  3. Under the Region tab
    1. Find Identification → Type, use Classic Report
  4. Under the Attributes tab
    1. Find Appearance → Template, use Timeline

Demo

  • toufiq 6 months ago
    On-Hold

    Arrange for vacation coverage

    6 months ago

  • toufiq 6 months ago
    On-Hold

    HR software upgrades

    6 months ago

  • toufiq 6 months ago
    Closed

    HR Support Systems

    6 months ago

  • toufiq 6 months ago
    Open

    Investigate new Virus Protection software

    6 months ago

  • toufiq 6 months ago
    Open

    Customize solutions

    6 months ago

  • toufiq 6 months ago
    Closed

    Install in development

    6 months ago

Template Options

Sample SQL Query

select
  p.id,
  substr(p.created_by,0,2) user_avatar,
  p.created event_date,
  lower(p.created_by) user_name,
  t.task_name event_title,
  t.created created,
  lower(t.created_by) owner,
  null event_desc,
  case status 
    when 'Open' then 'fa fa-clock-o'
    when 'Closed' then 'fa fa-check-circle-o'
    when 'On-Hold' then 'fa fa-exclamation-circle'
    when 'Pending' then 'fa fa-exclamation-triangle'
  end event_icon,
  case status 
    when 'Open' then 'is-new'
    when 'Closed' then 'is-removed'
    when 'On-Hold' then 'is-updated'
    when 'Pending' then 'is-updated'
  end event_status,
  status event_type,
  'u-color-'||( ora_hash(p.created_by,44) + 1 ) user_color
from
  eba_ut_chart_tasks t,
  eba_ut_chart_projects p
where
  t.project = p.id
order by p.created

Column Names

#EVENT_ATTRIBUTES#
Custom attributes for an event item
#EVENT_DATE#
Date of event displayed below user name
#EVENT_DESC#
Description of event displayed below event name
#EVENT_ICON#
Icon of event type.
#EVENT_LINK#
Link for the event
#EVENT_MODIFIERS#
CSS Class-based modifiers for an event item
#EVENT_STATUS#
Type of event. Substitute with "is-new", "is-updated" or "is-removed" for default styling.
#EVENT_TITLE#
Name of event
#EVENT_TYPE#
Type of the event
#USER_AVATAR#
User initials or image
#USER_COLOR#
Color applied to a user initials using u-color-XX classes or custom classes
#USER_NAME#
User name