topic Re: CMIS Query Folder error in Alfresco Archive

CMIS Query Folder error

francesco_forna — Wed, 07 Sep 2011 15:13:33 GMT

Dear All,I use Alfresco CE 3.4.d and I wrote a simple CMIS query:select cmisbjectId from cmis:folder where cmis:name = 'SITENAME'to find folders (sites) which are stored in the root site repository folder.The java code should be correct and the site is PRESENT in the repository Sites. But the CMIS

Re: CMIS Query Folder error

fmui — Wed, 07 Sep 2011 15:31:07 GMT

Hi Francesco,

Does your site show up when you run the query "select * from st:site" ?

- Florian

Re: CMIS Query Folder error

francesco_forna — Thu, 08 Sep 2011 07:42:34 GMT

Dear Florian,
thanks for your reply.

We have tried by using your suggestion but any result has been found.

In Alfresco repository we have, for example, two sites: site 03811 and site 03813.

For example, we have invoked Alfresco services (https protocol):

https://..../alfresco/service/cmis/query?q=SELECT cmisbjectId FROM st:site WHERE cmis:name='03811'

The site 03811 was found.

https://..../alfresco/service/cmis/query?q=SELECT cmisbjectId FROM st:site WHERE cmis:name='03813'

The site 03813 wasn't found.

It's really strange.

Moreover, we have tried by using the WHERE condition with the LIKE, but the site 03813 wasn't found.

By using the Alfresco CMIS browser, the 03813 folder has type st:site.

Any ideas?

Francesco.