This discussion is archived
0 Replies Latest reply: Nov 12, 2013 2:58 AM by dzy82f RSS

Problem using Gantt region plug-in

dzy82f Newbie
Currently Being Moderated

I’m trying to understand, and replicate, the use of the Gantt plug-in developed by Ivan Zderadicka in a similar way to that shown in the Apex Sample Charts packaged application (ID: 13030)

 

However when I try to use the code shown in the example

 

select

    pt.task_name parent_task,

    ct.task_name,

    ct.start_date,

    ct.end_date,

    case ct.status

when 'Open' then 'open_task'

when 'Closed' then 'closed_task'

when 'Pending' then 'pending_task'

else 'unknown_task'

    end child_class,

    ct.id,

    pt.id parent_id

from eba_demo_chart_tasks ct,

eba_demo_chart_tasks pt

where ct.parent_task is not null

   and pt.id = ct.parent_task

order by pt.task_name, ct.start_date

 

as the Region Source, I get an error “wrong number of columns selected in the region source query”

 

Any help anybody can provide on what I'm doing wrong would be much appreciated

 

Many thanks

 

Julian

 

Message was edited by: dzy82f It turns out that this Gantt plugin is not the one developed by Ivan Zderadicka but my thanks to him for providing more details on the SQL his plug-in uses Rather, it was developed by Oracle Internal Name (Value Required)    COM.ORACLE.APEX.GANTT_CHART Reference Master Plug-in From: 65708911358321918 It can be exported using in Application Builder ->  Application XXXX -> Shared Components -> Plug-ins, click on plug-in name which  takes you to the plug-in details page. On the right hand side, use "Export Plug-in" under "Tasks". Click this link and follow the wizard (with thanks to Hari_639)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points