cancel
Showing results for 
Search instead for 
Did you mean: 

How to access archived documents via CMIS

gregbpopstar
Champ on-the-rise
Champ on-the-rise
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/<id> in the node browser.  After the document is deleted, it is then accessible by archive://SpacesStore/<id> in the node browser.  It is the same document which as been archived and I can restore it if I like.

When a document is archived, it gets an archived aspect (sys:archived I believe), which I tried to query in CMIS with no success.

What I'd like to do:

I'd like to be able to access archived documents via CMIS and the Alfresco CMIS extension.  I've had success with queries like the following which produce CMIS output which contains aspect data.

select * from cmis:document d join cm:titled t on d.cmisSmiley Surprisedbjectid=t.cmisSmiley Surprisedbjectid
select * from cmis:document d join cm:author a on d.cmisSmiley Surprisedbjectid=a.cmisSmiley Surprisedbjectid
select * from cmis:document d join exif:exif x on d.cmisSmiley Surprisedbjectid=x.cmisSmiley Surprisedbjectid
select * from cmis:document d join rn:renditioned r on d.cmisSmiley Surprisedbjectid=r.cmisSmiley Surprisedbjectid
(or combinations or the above joins)

This query trying to access documents with the archived aspect does not return any results:
select * from cmis:document d join sys:archived sa on d.cmisSmiley Surprisedbjectid=sa.cmisSmiley Surprisedbjectid

I suspect it is because the archived documents are no longer in the same store and in a separate archived store.

Can anyone shed some light on how can I access these archived documents?
3 REPLIES 3

gregbpopstar
Champ on-the-rise
Champ on-the-rise
Any ideas?  Anyone?

It seams to me that the archive store should be accessible from CMIS given the right creds (admin).  I wouldn't think that would require any addition to the CMIS API.  Of course, I'm making the assumption that the archive store is just basically another store.  The node browser is able to browse it.

mgupta
Champ in-the-making
Champ in-the-making
Any replies to this?

jspuchau
Champ in-the-making
Champ in-the-making
I'm facing the same question

Have someone get any kind of solution about this?

Kind Regards!