1I have an aspect that I have associated with multiple documents. For example lests call the aspect OrderAspect.
The below query works when I fetch all nodes that have a location property from OrderAspect set to 'WAREHOUSE-A'
SELECT * FROM oarderAspect WHERE oa:Location ='WAREHOUSE-A'
1. How can I extend this query to get all documents that have this aspect and the location value as 'WAREHOUSE-A'
2. Can I extend this query to search within a folder path or sit? I would like to list all the documents within a folder (including subfolder) or a site that has OrderAspect with property location set to 'WAREHOUSE-A'.
Hi - Is there a way to do this? Would any expert be able to opine?
try like this you will get all the documents associated with aspect orderAspect of location 'warehouse'
SELECT * FROM cmis:document AS d JOIN oarderAspect as p ON d.cmis
bjectId = p.cmis
bjectId WHERE oa:Location ='WAREHOUSE-A'
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.