Hi all,
I have a parent child projects like below
Project 1
==> Project 1.1
===> Project 1.1.1
I want to display all of that projects that under Project 1. is there a way to do that?
TIA
Maybe provide query subject and query item names so there is less translation from my guesses to your actual solution.
One level deep? That's easy. Role play your Project query subject as ChildProject.
Queries:
Project
ChildProject - copy of Project
output - join Project and ChildProject on Project.ProjectNum = ChildProject.ParentProjectNum
All levels?
The query will need to use SQL written as a recursive CTE - probably using the pass-thru option.
Create visualizations as needed.