I would like to create a Spaces within Share where the Document Library for the Space is actually the result of a Query and is therefor dynamic.
For instance, I have a set of documents in the Repository with a custom aspect, I would like to create a Space that shows only these documents in the Sites Document Library no matter where they actuall reside in the Repository..
You cannot do this with Alfresco Share out-of-the-box. But, this is one of the features of <a href="http://www.alfresco.com/products/workdesk">Alfresco Workdesk</a> so you might want to take a look at that.
You could also implement this with your own custom application that utilizes the Alfresco API to make queries and produce a folder tree.