File System Structure Stub

The following sample specifies a folder structure on the Invantive Dummy connector, which contains project stubs:

Each folder contains a number of tasks on each project:

The levels are:

•Root folder

•Containing projects.

•Each containing tasks on the project.

The root folder with projects is defined using the following query:

select to_char(pjt.pjt_id) code

,      pjt.pjt_naam name

,      'DIR' type

from   projects pjt

Each project folder with individual tasks is defined using the following query:

select to_char(tak.tak_id) code

,      tak.tak_omschrijving name

,      'DIR' TYPE

from   tasks tak

where  tak.pjt_id = to_number(:code)