APEX

Hi Team,

APEX Version: 18.2.0.00.12

I am trying to create Gantt Chart with multiple tasks per row option. My expected output is like below.

https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=gantt&demo=multipleTasks

I did set-up a simple example to demonstrate my problem. (not in apex.oraclecorp.com as it's not on APEX 18.2)

Gantt Chart Series query:

SELECT 1 emp_id, 'Srihari' as emp_name, 1000 task_id, 'task 1000' task_name, sysdate - 5 start_date, sysdate - 3 end_date, 0 status from dual

union

SELECT 1 emp_id, 'Srihari' as emp_name, 1001 task_id, 'task 1001' task_name, sysdate - 1 start_date, sysdate + 1 end_date, 0 status from dual

union

SELECT 1 emp_id, 'Srihari' as emp_name, 1002 task_id, 'task 1002' task_name, sysdate + 2 start_date, sysdate + 3 end_date, 0 status from dual

union

SELECT 2 emp_id, 'Murari' as emp_name, 1003 task_id, 'task 1003' task_name, sysdate - 5 start_date, sysdate + 1 end_date, 0 status from dual

union

SELECT 2 emp_id, 'Murari' as emp_name, 1004 task_id, 'task 1004' task_name, sysdate + 2 start_date, sysdate + 5 end_date, 0 status from dual

Gantt Chart Series Attributes:

P16_START_DATE and P16_END_DATE are page items and I am setting initial values to these page items during page load.

But, when I run the page it says "No Data to Display Message".

Any idea what could be wrong with this Gantt chart? Am I missing something obvious somewhere? Please advise.

Regards,

Srihari