Skip to main content

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;

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.