Attributes

Attributes

Please refer to the usage page for a detailed explanation of how to use the plug-in. This page lists all the attributes that can be set in the plug-in.

Settings

 ROW ID

Resource ID (ProjectID, ClientID)

ROW NAME

Resource name (ProjectName, ClientName)

PARENT TASK ID

In case Parent task ID is selected query will automatically add CONNECT BY and START WITH.
Row ID and Row Label are not possible to select since tasks are in hierarchical mode.

TASK ID

Replace string for this column is APEX$GANTT_PK used in update statement and edit link.

TASK NAME

Display label on task

TASK START DATE

Start Date / Timestamp of task

TASK END DATE

End Date / Timestamp of task

TASK COLOR/STYLE

Decide background color or style.
To set task text color check CUSTOM attribute column.

Examples:

#ed6647 RED
#68c182 GREEN
#fad55c YELLOW

PROGRESS

Value to decide progress of task.
Range to have correct calculations is from 0 - 1. (0.50 is 50%)

BASELINE START DATE

Start date of a planning the task

BASELINE END DATE

End date of a planning the task

DOWNTIME START DATE

Start date of te task downtime

DOWNTIME END DATE

End date of te task downtime

OVERTIME START DATE

Start date of te task overtime

OVERTIME END DATE

End date of te task overtime

CUSTOM TASK SETTINGS

REGION Source column : Custom settings applied per task.

Examples:

{
    "height":22,
    "borderRadius":"10px",
    "labelPosition":"start",  //start | innerCenter | innerStart | innerEnd | end | none
    "labelStyle":{"fill":"blue"}, // color, cursor, fontFamily, fontSize, fontStyle, fontWeight, textDecoration
    "overlapBehavior":"auto",  //stack | stagger | overlay | auto
    "type":"normal", // normal | milestone | summary | auto
    "progress":{
             "borderRadius":"10px",
             "height":"75%",
             "svgStyle":{"fill":"brown"},
             "svgClassName":"classname"
    },
    "baseline":{
        "borderRadius":"5px",
        "height":4,
        "svgStyle":{"fill":"orange"},
        "svgClassName":"classname"
    },
    "downtime":{
        "svgStyle":{"fill":"orange"},
        "svgClassName":"classname"
    },
    "overtime":{
        "svgStyle":{"fill":"orange"},
        "svgClassName":"classname"
    }
}

VIEWPOINT START

This attribute is used to declare when timeline begins.
Practice is to create APEX item (Date picker) so user can decide timeline.
In case this is null inside page item Timeline starts with January 1st this year.

Additional Information:

Type: Item (Separate multiple values with a comma)

VIEWPOINT END DATE

This attribute is used to declare when timeline ends.
Practice is to create APEX item (Date picker) so user can decide timeline.
In case this is null inside page item Timeline ends with December 31st this year.

Additional Information:

Type: Item

UPDATE PL/SQL

PL/SQL Statement to update change on move or resize.

Examples:

UPDATE EBA_DEMO_CHART_TASKS
  SET START_DATE  = :APEX$GANTT_START_DATE,
      END_DATE    = :APEX$GANTT_END_DATE,
      ASSIGNED_TO = :APEX$GANTT_RESOURCE_ID
 WHERE ID = :APEX$GANTT_PK;

EDIT LINK

Link used to open modal or page with Primary key.
_To send PK use as value “APEX$GANTT/PK”, substitution of string is build inside plug-in.

DEPENDENCIES SQL

SQL Statement to get task dependencies.

Examples:

select ID,
       PREDECESSOR,
       SUCCESSOR,
       RELATION,
       STATUS,
       SHORTDESC
  from EBA_DEMO_CHART_TASKS_DEPEND_V;

TIME BUCKETS SQL

SQL Statement to get time buckets.

select TYPE,
       START_TIME,-- transformed to "start" used only when type = area
       END_TIME,  -- transformed to "end"   used only when type = area
       LINE_TIME, -- transformed to "value" used only when type = line
       SHORTDESC,
       SVGSTYLE
  from YOUR_HOLIDAY_DATES_TABLE;

Examples:

select 'area' TYPE,
       add_months(sysdate, -1) START_TIME,
       sysdate-10 END_TIME,
       null  LINE_TIME,
       'Time Bucket 1' SHORTDESC,
       '{ fill: "#32925e", opacity: "0.18" }' SVGSTYLE
  from dual
union all
select 'area' TYPE,
       sysdate+10 START_TIME,
       add_months(sysdate, 1) END_TIME,
       null  LINE_TIME,
       'Time Bucket 2' SHORTDESC,
       '{ fill: "#eb9632", opacity: "0.18" }' SVGSTYLE
  from dual
union all
select 'line' TYPE,
       null START_TIME,
       null END_TIME,
      add_months(sysdate, -1)  LINE_TIME,
       'Sprint Start' SHORTDESC,
       '{ stroke: "#db0000", opacity: "0.85" }' SVGSTYLE
  from dual
  union all
select 'line' TYPE,
       null START_TIME,
       null END_TIME,
       add_months(sysdate, 1)  LINE_TIME,
       'Sprint End' SHORTDESC,
       '{ stroke: "#db0000", opacity: "0.85" }' SVGSTYLE
  from dual;

TOOLTIP

Decide which type of tooltip will be used during rendering Gantt.

Default tooltip => Automatic build in
Column source => Gather that from query
HTML template => Used for custom HTML code

<div>
  <div style = "float:left; padding: 10px 8px 10px 3px">
    <span style="font-weight: bold"><oj-bind-text value="[['Assigned: ' + tooltip.data.resource]]"></oj-bind-text></span><br/>
    <span><oj-bind-text value="[['Start Date: ' + tooltip.data.start]]"></oj-bind-text></span><br/>
    <span><oj-bind-text value="[['End Date: ' + tooltip.data.end]]"></oj-bind-text></span>
  </div>
  <oj-status-meter-gauge id="gauge"
        min="0"
        max="1"
        value="{{tooltip.data.progress.value}}"
        orientation="circular"
        color="[[tooltip.color]]"
        metric-label.text="[[(tooltip.data.progress.value * 100)+ ' %']]"
        readonly
        style=
        "float:right;
        padding-top:10px;
        width:80px;
        height:80px;">
  </oj-status-meter-gauge>
</div>

Layout

 NUMBER OF ROWS TYPE

Select how the number of rows for this report are entered

Available options include:

Static Value

Based on Item Value

ITEM

Select the item whose value specifies the number of report rows to display per report page.