topic How to access archived documents via CMIS in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267214#M220344 <HTML><HEAD></HEAD><BODY><SPAN>Is there any way to access archived documents via CMIS?</SPAN><BR /><BR /><STRONG>Background:</STRONG><BR /><BR /><SPAN>In Alfresco Explorer I am able to delete a document which before I delete it is accessible by workspace://SpacesStore/&lt;id&gt; in the node browser.&nbsp; After the document is deleted, it is then accessible by archive://SpacesStore/&lt;id&gt; in the node browser.&nbsp; It is the same document which as been archived and I can restore it if I like.</SPAN><BR /><BR /><SPAN>When a document is archived, it gets an archived aspect (sys:archived I believe), which I tried to query in CMIS with no success.</SPAN><BR /><BR /><STRONG>What I'd like to do:</STRONG><BR /><BR /><SPAN>I'd like to be able to access archived documents via CMIS and the Alfresco CMIS extension.&nbsp; I've had success with queries like the following which produce CMIS output which contains aspect data.</SPAN><BR /><BR /><SPAN>select * from cmis:document d join cm:titled t 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=t.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</SPAN><BR /><SPAN>select * from cmis:document d join cm:author a 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=a.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</SPAN><BR /><SPAN>select * from cmis:document d join exif:exif x 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=x.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</SPAN><BR /><SPAN>select * from cmis:document d join rn:renditioned r 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=r.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</SPAN><BR /><SPAN>(or combinations or the above joins)</SPAN><BR /><BR /><SPAN>This query trying to access documents with the archived aspect does not return any results:</SPAN><BR /><SPAN>select * from cmis:document d join sys:archived sa 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=sa.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</SPAN><BR /><BR /><SPAN>I suspect it is because the archived documents are no longer in the same store and in a separate archived store.</SPAN><BR /><BR /><STRONG>Can anyone shed some light on how can I access these archived documents?</STRONG></BODY></HTML> Fri, 20 May 2011 20:39:56 GMT gregbpopstar 2011-05-20T20:39:56Z How to access archived documents via CMIS https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267214#M220344 Is there any way to access archived documents via CMIS?Background:In Alfresco Explorer I am able to delete a document which before I delete it is accessible by workspace://SpacesStore/&lt;id&gt; in the node browser.&nbsp; After the document is deleted, it is then accessible by archive://SpacesStore/&lt;i Fri, 20 May 2011 20:39:56 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267214#M220344 gregbpopstar 2011-05-20T20:39:56Z Re: How to access archived documents via CMIS https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267215#M220345 <HTML><HEAD></HEAD><BODY><SPAN>Any ideas?&nbsp; Anyone?</SPAN><BR /><BR /><SPAN>It seams to me that the archive store should be accessible from CMIS given the right creds (admin).&nbsp; I wouldn't think that would require any addition to the CMIS API.&nbsp; Of course, I'm making the assumption that the archive store is just basically another store.&nbsp; The node browser is able to browse it.</SPAN></BODY></HTML> Wed, 01 Jun 2011 19:39:16 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267215#M220345 gregbpopstar 2011-06-01T19:39:16Z Re: How to access archived documents via CMIS https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267216#M220346 <HTML><HEAD></HEAD><BODY><SPAN>Any replies to this?</SPAN></BODY></HTML> Thu, 16 Feb 2012 18:59:02 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267216#M220346 mgupta 2012-02-16T18:59:02Z Re: How to access archived documents via CMIS https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267217#M220347 <HTML><HEAD></HEAD><BODY><SPAN>I'm facing the same question</SPAN><BR /><BR /><SPAN>Have someone get any kind of solution about this?</SPAN><BR /><BR /><SPAN>Kind Regards!</SPAN></BODY></HTML> Thu, 30 May 2013 08:24:56 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-access-archived-documents-via-cmis/m-p/267217#M220347 jspuchau 2013-05-30T08:24:56Z