I have a site collection with different sub sites:
A (Root) B (Program Site) B (Program Site) C(Projects Site) D(Projects Site) E(Projects Site) Issues List Issues List Issues List
I'm trying to create a Dataview in Program site level where: - Get All Issues from Projects sub sites - With "priority"= Medium
Note: The issues site lists have the same content type = Issues and I need to do this with SharePoint designer.
Thank You in advance