Folders not recovered

[tremalnaik]

Hi!

I continue working with Web Scripts and I have another problem.

I've created a nes Space called "California". If I search this Space with the Get Object and the objectTipe is cmis:folder

Well, now I'm using the Web Script which sends a CMIS Query like this

SELECT * FROM cmis:folder WHERE cmis:name IN ('California')‍

or

SELECT * FROM cmis:folder WHERE cmis:name LIKE 'California'‍

always the result is '0'. Needs the Spaces some special to be recovery by this Web Script? Thanks

[openpj]

Have you tried with the following?

SELECT * FROM cmis:folder WHERE cmis:name = 'California'‍

or

SELECT * FROM cmis:folder WHERE cmis:name = 'Californi*'‍

Hope this helps.

[tremalnaik]

Hi OpenPj,

Anything ot twice has worked… I have revised de DataBase and the Folder exists!

[openpj]

Could you use the Alfresco Node Browser and show us exactly all the properties of this node that you want to get?

[tremalnaik]

Hi OpenPj,

This the XML Response. I've deleted the <link> tags cos' I thought they are not important.

<?xml version="1.0" encoding="UTF-8"?>
<entry>

 <content src="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/20fc1b08-1140-4052-915b-d12e01...>

 <id>urn:uuid:20fc1b08-1140-4052-915b-d12e018553d9</id>

 <published>2011-11-24T16:39:42.932+01:00</published>

 <summary></summary>
 
 <title>California</title>
 
 <updated>2011-11-24T16:39:42.932+01:00</updated>
 
 <app:edited>2011-11-24T16:39:42.932+01:00</app:edited>
 
 <cmisra:object>
   <cmis:properties>
     <cmis:propertyId propertyDefinitionId="cmis:allowedChildObjectTypeIds"  displayName="Allowed Child Object Types Ids" queryName="cmis:allowedChildObjectTypeIds"/>
     
     <cmis:propertyString propertyDefinitionId="cmis:path" displayName="Path" queryName="cmis:path">
       <cmis:value>/California</cmis:value>
     </cmis:propertyString>
     
     <cmis:propertyString propertyDefinitionId="cmis:lastModifiedBy" displayName="Last Modified By" queryName="cmis:lastModifiedBy">
       <cmis:value>admin</cmis:value>
     </cmis:propertyString>
     
     <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Object Type Id" queryName="cmis:objectTypeId">
       <cmis:value>cmis:folder</cmis:value>
     </cmis:propertyId>
     
     <cmis:propertyString propertyDefinitionId="cmis:createdBy" displayName="Created by" queryName="cmis:createdBy">
       <cmis:value>admin</cmis:value>
     </cmis:propertyString>
     
     <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" queryName="cmis:name">
       <cmis:value>California</cmis:value>
     </cmis:propertyString>
     
     <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object Id" queryName="cmis:objectId">
       <cmis:value>workspace://SpacesStore/20fc1b08-1140-4052-915b-d12e018553d9</cmis:value>
     </cmis:propertyId>
     
     <cmis:propertyDateTime propertyDefinitionId="cmis:creationDate" displayName="Creation Date" queryName="cmis:creationDate">
       <cmis:value>2011-11-24T16:39:42.932+01:00</cmis:value>
     </cmis:propertyDateTime>
     
     <cmis:propertyString propertyDefinitionId="cmis:changeToken" displayName="Change token" queryName="cmis:changeToken"/>
     
     <cmis:propertyId propertyDefinitionId="cmis:baseTypeId" displayName="Base Type Id" queryName="cmis:baseTypeId">
       <cmis:value>cmis:folder</cmis:value>
     </cmis:propertyId>
     
     <cmis:propertyId propertyDefinitionId="cmis:parentId" displayName="Parent Id" queryName="cmis:parentId">
       <cmis:value>workspace://SpacesStore/b4440a33-de67-4b72-ab34-8a06205c6301</cmis:value>
     </cmis:propertyId>
     
     <cmis:propertyDateTime propertyDefinitionId="cmis:lastModificationDate" displayName="Last Modified Date" queryName="cmis:lastModificationDate">
       <cmis:value>2011-11-24T16:39:42.932+01:00</cmis:value>
     </cmis:propertyDateTime>
     
     <alf:aspects>
       <alf:appliedAspects>P:app:uifacets</alf:appliedAspects>
       <alf:appliedAspects>P:cm:titled</alf:appliedAspects>
       
       <alf:properties>
         <cmis:propertyString propertyDefinitionId="app:icon" displayName="Icono" queryName="app:icon">
           <cmis:value>space-icon-default</cmis:value>
         </cmis:propertyString>
         
         <cmis:propertyString propertyDefinitionId="cm:description" displayName="Descripción" queryName="cm:description">
           <cmis:value></cmis:value>
         </cmis:propertyString>
         
         <cmis:propertyString propertyDefinitionId="cm:title" displayName="Título" queryName="cm:title">
           <cmis:value></cmis:value>
         </cmis:propertyString>
       </alf:properties>
     </alf:aspects>
   </cmis:properties>
 </cmisra:object>
 <cmisra:pathSegment>California</cmisra:pathSegment>
</entry>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[openpj]

I tried the same query that I suggested in the previous post and it works for me.
But could you share all the details taking properties using the Alfresco Node Browser?

I mean I think that probably you have some problems with child names for some child association references.

[tremalnaik]

Apart from my XML extracted from the "Alfresco Node Reference", in the "Details Page" I have the next:

Location: /Company Home
Name:   California
Title:   
Description:
Creator:   admin
Created Date:   24 November 2011 16:39
Modifier:   admin
Modified Date:   24 November 2011 16:39
Email ID:   5589

I haven't Workflows, Categories and Rules.

I don't know if you are referring to this information.


Thanks

[tremalnaik]

The only difference between one folder recovered and this one that fails are these lines:

<alf:appliedAspects>P:app:uifacets</alf:appliedAspects>

<cmis:propertyString propertyDefinitionId="app:icon" displayName="Icono" queryName="app:icon">
  <cmis:value>space-icon-default</cmis:value>
</cmis:propertyString>‍‍‍‍‍‍