topic Re: Extending CMIS query to get all documents with a property in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56241#M20422 <HTML><HEAD></HEAD><BODY><P>Hi - Is there a way to do this? Would any expert be able to opine?</P></BODY></HTML> Mon, 20 Aug 2018 10:29:18 GMT kartech11 2018-08-20T10:29:18Z Extending CMIS query to get all documents with a property https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56240#M20421 1I have an aspect that I have associated with multiple documents. For example lests call the aspect OrderAspect.&nbsp;The below query works when I fetch all nodes that have a location property from OrderAspect set to 'WAREHOUSE-A'SELECT * FROM oa<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rderAspect WHERE oa:Location&nbsp;='WAREHOUSE-A' &nbsp;1. How can I Thu, 16 Aug 2018 15:19:36 GMT https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56240#M20421 kartech11 2018-08-16T15:19:36Z Re: Extending CMIS query to get all documents with a property https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56241#M20422 <HTML><HEAD></HEAD><BODY><P>Hi - Is there a way to do this? Would any expert be able to opine?</P></BODY></HTML> Mon, 20 Aug 2018 10:29:18 GMT https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56241#M20422 kartech11 2018-08-20T10:29:18Z Re: Extending CMIS query to get all documents with a property https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56242#M20423 <HTML><HEAD></HEAD><BODY><P>try like this you will get all the documents associated with aspect orderAspect of location 'warehouse'</P><P></P><P>SELECT * FROM cmis:document AS d JOIN oa<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rderAspect as p ON d.cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId = p.cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId WHERE oa:Location ='WAREHOUSE-A'&nbsp;</P></BODY></HTML> Mon, 20 Aug 2018 10:34:00 GMT https://connect.hyland.com/t5/alfresco-forum/extending-cmis-query-to-get-all-documents-with-a-property/m-p/56242#M20423 kranthi 2018-08-20T10:34:00Z