CMIS how to fetch a document by it's objectId

Question

i'm trying to fetch document from alfresco using CMIS queries and all i have is there object id i tried the following but it returned 'bad request'

SELECT * FROM cmis:document where cmis:objectId = workspace://SpacesStore/89332e83-1a43-41fe-ba8d-2facdf317d05

I apologize i forgot to mention that i'm using CMIS with javascript Thank you .

Why are you doing a query? Why not do a direct object fetch? (You haven't said what library you're using so we can't really help...) — Gagravarr, May 10 '17 at 21:04
sadly not because im using JAVASCRIPT AND CMIS queries to fetch the data not java — Ayoub Idelhoussain, Jun 09 '17 at 13:51
Be careful about assuming that the Alfresco node reference, which is what you are showing, is the same thing as a CMIS object ID. They are not the same thing. — Jeff Potts, Jun 09 '17 at 19:15

score 1 · Answer 1 · answered May 11 '17 at 07:18

When you have the ID you don't need to use a query you can get it directly from the session object.

Typically for Java you can do something like this :

CmisObject cmisObject = session.getObject(id);

if (cmisObject instanceof Document) {
    Document document = (Document) cmisObject;
} else if (cmisObject instanceof Folder) {
    Folder folder = (Folder) cmisDocument;
}

score 0 · Answer 2 · edited May 23 '17 at 11:54

Simplly with CMIS there is two ways to get an object (File or Folder) :

Before getting the object you need to get your alfresco session, read this post : How to get Session in Alfresco using CMIS.

Getting an object by path

CmisObject object = session.getObjectByPath(pathObject);

Getting an object by ID

CmisObject object = session.getObject(idObject);

After getting the object you can cast it to File or Folder

You can also read this post to understand how to get document with query using a Folder ID How to get a document using Folder ID.

Hope that Helped you.

CMIS how to fetch a document by it's objectId

2 Answers2

Linked