source: NASA
Buffering...
source: RightNow community documentation
| dept_id | dept_name | parent_dept_id |
|---|---|---|
| 1 | ACME Corp | null |
| 2 | Widgets | 1 |
| 3 | Corporate | 1 |
| 4 | Widget marketing | 2 |
| 5 | Widget engineering | 2 |
| employee_id | dept_id | employee_name |
|---|---|---|
| 1 | 1 | John |
| 2 | 2 | Mary |
| 3 | 3 | Steve |
| 4 | 3 | James |
| 5 | 4 | David |
| 6 | 4 | Liz |
| 7 | 5 | Dan |
start department = node:Department(name='Widgets')
match employee -[:works_in]-> sub_department
-[0..*:parent]-> department
return employee
Alistair Jones
alistair.jones@neotechnology.com
@apcj