mirror of
https://github.com/go-vikunja/vikunja.git
synced 2026-07-18 15:52:38 -05:00
ac76bce5cd
Resolves #2490. Users with team access on a parent project were not seeing subtask relations for tasks in child projects because getUserProjectsStatement does not walk the project hierarchy. The fix wraps the base query in a recursive CTE that traverses child projects via parent_project_id.
104 lines
2.1 KiB
YAML
104 lines
2.1 KiB
YAML
- id: 1
|
|
team_id: 1
|
|
project_id: 3
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# This team has read only access on project 6
|
|
- id: 2
|
|
team_id: 2
|
|
project_id: 6
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# This team has write access on project 7
|
|
- id: 3
|
|
team_id: 3
|
|
project_id: 7
|
|
permission: 1
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# This team has admin access on project 8
|
|
- id: 4
|
|
team_id: 4
|
|
project_id: 8
|
|
permission: 2
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# Readonly acces on project 19
|
|
- id: 5
|
|
team_id: 8
|
|
project_id: 19
|
|
permission: 2
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# Write acces on project 19
|
|
- id: 6
|
|
team_id: 9
|
|
project_id: 19
|
|
permission: 1
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# Admin acces on project 19
|
|
- id: 7
|
|
team_id: 10
|
|
project_id: 19
|
|
permission: 2
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 8
|
|
team_id: 1
|
|
project_id: 21
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 9
|
|
team_id: 1
|
|
project_id: 28
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 10
|
|
team_id: 11
|
|
project_id: 29
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 11
|
|
team_id: 12
|
|
project_id: 29
|
|
permission: 1
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 12
|
|
team_id: 13
|
|
project_id: 29
|
|
permission: 2
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 13
|
|
team_id: 1
|
|
project_id: 32
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 14
|
|
team_id: 1
|
|
project_id: 33
|
|
permission: 1
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
- id: 15
|
|
team_id: 1
|
|
project_id: 34
|
|
permission: 2
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|
|
# Team 16 has read access on project 41 (the parent) — hierarchy permission test
|
|
- id: 16
|
|
team_id: 16
|
|
project_id: 41
|
|
permission: 0
|
|
updated: 2018-12-02 15:13:12
|
|
created: 2018-12-01 15:13:12
|