Parent Section or ID of parent folder of a document

[foxtrot1213]

Hi there,

Could you please tell me how to get the ID of parent folder of a document? When I run a CMIS query then I get the following outputs:

<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns:cmisra="http://docs.oasis-open.org/ns/cmis/restatom/200908/" xmlns:cmis="http://docs.oasis-open.org/ns/cmis/core/200908/" xmlns:alf="http://www.alfresco.org" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/">
<author><name>admin</name></author>
<generator version="3.4.0 (d 3370)">Alfresco (Community)</generator>
<icon>http://50.57.98.252:8080/alfresco/images/logo/AlfrescoLogo16.ico</icon>
<id>http://www.alfresco.org/rss/atom/urn:uuid:resultset</id>
<link rel="service" href="http://50.57.98.252:8080/alfresco/service/cmis'/>
<link rel="self" href="http://50.57.98.252:8080/alfresco/service/cmis/queries'/>
<link rel="first" href="http://50.57.98.252:8080/alfresco/service/cmis/query?q=SELECT%20*%20FROM%20cmis:document%20WHERE%20c..." type="application/atom+xml;type=feed"/>
<link rel="last" href="http://50.57.98.252:8080/alfresco/service/cmis/query?q=SELECT%20*%20FROM%20cmis:document%20WHERE%20c..." type="application/atom+xml;type=feed"/>
<title>Result set for SELECT * FROM cmis:document WHERE cmis:name LIKE &apos;105.html&apos;</title>
<updated>2011-08-31T08:46:19.284Z</updated>
<opensearch:totalResults>1</opensearch:totalResults>
<opensearch:startIndex>0</opensearch:startIndex>
<opensearch:itemsPerPage>-1</opensearch:itemsPerPage>
<cmisra:numItems>1</cmisra:numItems>
<entry>
<author><name>admin</name></author>
<content type="text/html" src="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...><id>urn:uuid:c2696cc3-5734-4f81-93bd-e260491aef26</id>
<link rel="self" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="edit" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="enclosure" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26..." type="text/html"/>
<link rel="edit-media" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26..." type="text/html"/>
<link rel="http://docs.oasis-open.org/ns/cmis/link/200908/allowableactions" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="http://docs.oasis-open.org/ns/cmis/link/200908/relationships" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="http://docs.oasis-open.org/ns/cmis/link/200908/policies" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="http://docs.oasis-open.org/ns/cmis/link/200908/acl" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="up" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26..." type="application/atom+xml;type=feed"/>
<link rel="version-history" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="current-version" href="http://50.57.98.252:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/c2696cc3-5734-4f81-93bd-e26...>
<link rel="describedby" href="http://50.57.98.252:8080/alfresco/service/cmis/type/D:ws:article'/>
<link rel="service" href="http://50.57.98.252:8080/alfresco/service/cmis'/>
<title>105.html</title>
<updated>2011-08-02T12:43:22.434Z</updated>
<alf:icon>http://50.57.98.252:8080/alfresco/images/filetypes/html.gif</alf:icon>
<cmisra:object>
<cmis:properties>
<cmis:propertyBoolean propertyDefinitionId="cmis:isLatestMajorVersion" displayName="Is Latest Major Version" queryName="cmis:isLatestMajorVersion"><cmis:value>false</cmis:value></cmis:propertyBoolean>
<cmis:propertyId propertyDefinitionId="cmis:contentStreamId" displayName="Content Stream Id" queryName="cmis:contentStreamId"><cmis:value>store://2011/8/2/12/43/8ec74a2b-7e5a-4039-9882-b695b9a8b7af.bin</cmis:value></cmis:propertyId>
<cmis:propertyInteger propertyDefinitionId="cmis:contentStreamLength" displayName="Content Stream Length" queryName="cmis:contentStreamLength"><cmis:value>2206</cmis:value></cmis:propertyInteger>
<cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Object Type Id" queryName="cmis:objectTypeId"><cmis:value>D:ws:article</cmis:value></cmis:propertyId>
<cmis:propertyString propertyDefinitionId="cmis:versionSeriesCheckedOutBy" displayName="Version Series Checked Out By" queryName="cmis:versionSeriesCheckedOutBy"/>
<cmis:propertyId propertyDefinitionId="cmis:versionSeriesCheckedOutId" displayName="Version Series Checked Out Id" queryName="cmis:versionSeriesCheckedOutId"/>
<cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" queryName="cmis:name"><cmis:value>105.html</cmis:value></cmis:propertyString>
<cmis:propertyString propertyDefinitionId="cmis:contentStreamMimeType" displayName="Content Stream MIME Type" queryName="cmis:contentStreamMimeType"><cmis:value>text/html</cmis:value></cmis:propertyString>
<cmis:propertyId propertyDefinitionId="cmis:versionSeriesId" displayName="Version series id" queryName="cmis:versionSeriesId"><cmis:value>workspace://SpacesStore/c2696cc3-5734-4f81-93bd-e260491aef26</cmis:value></cmis:propertyId>
<cmis:propertyDateTime propertyDefinitionId="cmis:creationDate" displayName="Creation Date" queryName="cmis:creationDate"><cmis:value>2011-08-02T12:43:22.434Z</cmis:value></cmis:propertyDateTime>
<cmis:propertyString propertyDefinitionId="cmis:changeToken" displayName="Change token" queryName="cmis:changeToken"/>
<cmis:propertyBoolean propertyDefinitionId="cmis:isLatestVersion" displayName="Is Latest Version" queryName="cmis:isLatestVersion"><cmis:value>true</cmis:value></cmis:propertyBoolean>
<cmis:propertyString propertyDefinitionId="cmis:versionLabel" displayName="Version Label" queryName="cmis:versionLabel"><cmis:value>0.0</cmis:value></cmis:propertyString>
<cmis:propertyBoolean propertyDefinitionId="cmis:isVersionSeriesCheckedOut" displayName="Is Version Series Checked Out" queryName="cmis:isVersionSeriesCheckedOut"><cmis:value>false</cmis:value></cmis:propertyBoolean>
<cmis:propertyString propertyDefinitionId="cmis:lastModifiedBy" displayName="Last Modified By" queryName="cmis:lastModifiedBy"><cmis:value>admin</cmis:value></cmis:propertyString>
<cmis:propertyString propertyDefinitionId="cmis:createdBy" displayName="Created by" queryName="cmis:createdBy"><cmis:value>admin</cmis:value></cmis:propertyString>
<cmis:propertyString propertyDefinitionId="cmis:checkinComment" displayName="Checkin Comment" queryName="cmis:checkinComment"/>
<cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object Id" queryName="cmis:objectId"><cmis:value>workspace://SpacesStore/c2696cc3-5734-4f81-93bd-e260491aef26</cmis:value></cmis:propertyId>
<cmis:propertyBoolean propertyDefinitionId="cmis:isMajorVersion" displayName="Is Major Version" queryName="cmis:isMajorVersion"><cmis:value>false</cmis:value></cmis:propertyBoolean>
<cmis:propertyBoolean propertyDefinitionId="cmis:isImmutable" displayName="Is Immutable" queryName="cmis:isImmutable"><cmis:value>false</cmis:value></cmis:propertyBoolean>
<cmis:propertyId propertyDefinitionId="cmis:baseTypeId" displayName="Base Type Id" queryName="cmis:baseTypeId"><cmis:value>cmis:document</cmis:value></cmis:propertyId>
<cmis:propertyDateTime propertyDefinitionId="cmis:lastModificationDate" displayName="Last Modified Date" queryName="cmis:lastModificationDate"><cmis:value>2011-08-02T12:43:22.434Z</cmis:value></cmis:propertyDateTime>
<cmis:propertyString propertyDefinitionId="cmis:contentStreamFileName" displayName="Content Stream Filename" queryName="cmis:contentStreamFileName"><cmis:value>105.html</cmis:value></cmis:propertyString>
</cmis:properties>
</cmisra:object>
</entry>
</feed>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The IDs that you are seeing are the IDs of document, not the ID of parent folder.
However, when I see the details of that particular document in Alfresco Share then I can see the following line in details section:

Parent sections:   workspace://SpacesStore/c853e557-ac01-40e4-a515-f6146a1d6ede
‍‍‍

There must be some way to get the ID of parent folder. I just can't figure out the magic word/parameter

Thanks in advance

[foxtrot1213]

never mind
solved:

SELECT * FROM cmis:document WHERE cmis:name LIKE '152.html' AND IN_FOLDER('workspace://SpacesStore/33428933-aabf-46d3-834f-d7e6ea528a63')
‍‍‍