The following sample specifies a folder structure on the Invantive Dummy connector, which contains project stubs:
*Dynamic list of projects on FTP server.*
Each folder contains a number of tasks on each project:
*Dynamic list of tasks per project on FTP server.*
The levels are:
- Root folder
- Containing projects.
- Each containing tasks on the project.
The root folder with projects is defined using the following query:
```sql
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:
```sql
select to_char(tak.tak_id) code
, tak.tak_omschrijving name
, 'DIR' TYPE
from tasks tak
where tak.pjt_id = to_number(:code)
```