Is it possible to get a list of all (open) tasks for a website collection?
I checked Sharepoint 2013 task list of all tasks created already but this approach isn't exactly what we need. For each project we create a project site under a specifc websitecollection "projects". Our project portfolio managers needs a list of all tasks of all projects. Even when he hasn't created the task by himself (that's the requirement, the solution above can't solve).
The ideal solution would be a hierarchical list where the projects are the parents and the tasks are the child items.