Question about grabbing document properties

gereeyehrmo — Thu, 21 Nov 2013 21:32:34 GMT

So I am having trouble with the description property from the service from my local alfresco server. Here's what I am using:Alfresco Version: Community Edition 4.2eService API URL: http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom/queryData sent to service: <?xml versio

Re: Question about grabbing document properties

jpotts — Fri, 22 Nov 2013 21:17:05 GMT

I'm not sure that contains clause is going to get you documents with that tag. So let's put that aside and modify your query to find objects with a certain name. You are looking for description. That's defined in an aspect. When need to select properties defined in an aspect you have to use a join. So the query to return the name and description for an object named 'coins.JPG' would look like this:

SELECT D.cmis:name,T.cm:description FROM cmis:document as D join cm:titled as T on D.cmis:objectId = T.cmis:objectId WHERE D.cmis:name='coins.JPG' ORDER BY D.cmis:lastModificationDate DESC‍

Jeff

topic Re: Question about grabbing document properties in Alfresco Archive

Question about grabbing document properties

Re: Question about grabbing document properties