topic Combine queries in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301367#M254497 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I wonder if there is any way to combine multiple queries.</SPAN><BR /><SPAN>To be more specific I have to do a search on several custom aspects.</SPAN><BR /><SPAN>An example for the queries to combine are the following:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>and</SPAN><BR /><PRE class="language-none line-numbers"><CODE>select d.cmis:objectId from cmis:document as d join accident:foto as a on d.cmis:objectId = a.cmis:objectId<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>these two queries give me results. I've tried:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId join accident:foto as f on d.cmis:objectId = f.cmis:objectId;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>but this won't give me any results.</SPAN><BR /><SPAN>Then I tried with the union</SPAN><BR /><PRE class="language-none line-numbers"><CODE>select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId union select d.cmis:objectId from cmis:document as d join accident:foto as a on d.cmis:objectId = a.cmis:objectId<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>but this returns me the error that the "Union" is unknown.</SPAN><BR /><SPAN>I'm using opencmis.</SPAN><BR /><BR /><SPAN>Has anyone an idea?</SPAN></BODY></HTML> Mon, 28 Oct 2013 14:02:51 GMT mundi 2013-10-28T14:02:51Z Combine queries https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301367#M254497 Hi,I wonder if there is any way to combine multiple queries.To be more specific I have to do a search on several custom aspects.An example for the queries to combine are the following:select d.cmis<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" />bjectId from cmis:document as d join accident:reponse as a on d.cmis<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" />bjectId = a.cmis<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" />bjectId‍andse Mon, 28 Oct 2013 14:02:51 GMT https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301367#M254497 mundi 2013-10-28T14:02:51Z Re: Combine queries https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301368#M254498 <HTML><HEAD></HEAD><BODY><SPAN>keyword Union is not included in CMIS query specification</SPAN></BODY></HTML> Mon, 28 Oct 2013 15:24:02 GMT https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301368#M254498 kaynezhang 2013-10-28T15:24:02Z Re: Combine queries https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301369#M254499 <HTML><HEAD></HEAD><BODY><SPAN>So is there any other way to combine queries?</SPAN></BODY></HTML> Mon, 28 Oct 2013 16:04:54 GMT https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301369#M254499 mundi 2013-10-28T16:04:54Z Re: Combine queries https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301370#M254500 <HTML><HEAD></HEAD><BODY><SPAN>Using CMIS query ,as far as I know there is no way.</SPAN></BODY></HTML> Tue, 29 Oct 2013 13:36:02 GMT https://connect.hyland.com/t5/alfresco-archive/combine-queries/m-p/301370#M254500 kaynezhang 2013-10-29T13:36:02Z