nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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')‍

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

Find more posts tagged with

Comments

openpj

Have you tried with the following?

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

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-d12e018553d9/content'/>

 <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>‍‍‍‍‍‍