Hi! A customer would like to see a list of Projects with their Sub Projects. Only those projects that have childs with some general information from the project properties including some custom fields.
Has anyone done something like this? I've found a query for hierarchical projects and sub-project but it only shows name and id for the project and the sub project. It does show the data as I expect but the query is really too complex to me in order to modify it to bring also the custom fields.
I'm attaching the query, sorry I don't have the link for the post where we found it.
I really appreciate your help.