chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geert Vanheusden <>
Subject Re: Problem executing JOIN query in combination with IN_TREE or IN_FOLDER
Date Tue, 01 Feb 2011 12:39:58 GMT
Hi Florian,

Sorry for the misplaced question, but thanks for the reference to the section in the CMIS
specifications! It solved our problem.

Kind regards,

Geert & Mano

----- Original Message -----
From: "Florian Müller" <>
To: "g vanheusden" <>
Sent: Tuesday, February 1, 2011 12:48:52 PM
Subject: Re: Problem executing JOIN query in combination with IN_TREE or IN_FOLDER

Hi Geert,

First of all, this an Alfresco question and not an OpenCMIS question. The Alfresco CMIS forum
would be a better place for those kind of issues.

Your query is missing a qualifier parameter in the IN_TREE function. This parameter is mandatory
for queries that do JOINs.
(See CMIS specification section " IN_TREE() predicate function".)



On 01/02/2011 11:30, Geert Vanheusden wrote:
> Hi all,
> We get the following error when executing a query:
> org.alfresco.scripts.ScriptException: 01010002 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/':
01010001 Selector must be specified for child constraint (IN_TREE) and join
> 	at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(
> 	at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(
> 	at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(
> 	at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(
> 	at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(
> This is caused by the following query:
AS EMPLOYEEDOCUMENT ON DOCUMENT.cmis:objectId = EMPLOYEEDOCUMENT.cmis:objectId WHERE (IN_TREE('workspace://SpacesStore/89fbb2b2-2992-4104-9cec-cd2c15fb95e7')
AND DOCUMENT.cmis:objectId IN ('workspace://SpacesStore/f0e7d3e7-cb74-4993-ad61-87042ca6de72'))
> This query contains JOIN predicates because we are using aspects, supported by the alfresco
CMIS implementation. We use the "Alfresco OpenCMIS Extension" library (found here:
to easily add and remove aspects in our code.
> We were wondering if this is a problem with our query or if this is a bug in Alfresco.
> Thanks in advance.
> -- Geert&  Mano
> _________________________________________________
>   We published a new company movie featuring YOU!
>           See
> _________________________________________________

View raw message