Mailing-List: contact chemistry-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: chemistry-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Date: Tue, 1 Feb 2011 13:39:58 +0100 (CET)
From: Geert Vanheusden <g.vanheusden@aca-it.be>
To: =?utf-8?Q?Florian_M=C3=BCller?= <florian.mueller@alfresco.com>
Cc: chemistry-dev@incubator.apache.org
Message-ID: <1788900691.22632.1296563998365.JavaMail.root@itshas-sv06>
In-Reply-To: <4D47F324.6040206@alfresco.com>
Subject: Re: Problem executing JOIN query in combination with IN_TREE or
 IN_FOLDER
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi Florian,

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

Kind regards,

Geert & Mano

----- Original Message -----
From: "Florian M=C3=BCller" <florian.mueller@alfresco.com>
To: "g vanheusden" <g.vanheusden@aca-it.be>
Cc: chemistry-dev@incubator.apache.org
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 A=
lfresco 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 p=
arameter is mandatory for queries that do JOINs.
(See CMIS specification section "2.1.10.2.4.6 IN_TREE() predicate function"=
.)


Regards,

Florian


On 01/02/2011 11:30, Geert Vanheusden wrote:
> Hi all,
>=20
> We get the following error when executing a query:
>=20
> org.alfresco.scripts.ScriptException: 01010002 Failed to execute script '=
classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmi=
squery.js': 01010001 Selector must be specified for child constraint (IN_TR=
EE) and join
> =09at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptP=
rocessor.java:194)
> =09at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptS=
erviceImpl.java:282)
> =09at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScri=
pt(RepositoryScriptProcessor.java:102)
> =09at org.springframework.extensions.webscripts.AbstractWebScript.execute=
Script(AbstractWebScript.java:981)
> =09at org.springframework.extensions.webscripts.DeclarativeWebScript.exec=
ute(DeclarativeWebScript.java:86)
>=20
>=20
> This is caused by the following query:
>=20
> SELECT DOCUMENT.*, EMPLOYEEDOCUMENT.* FROM park:document AS DOCUMENT JOIN=
 park:employeeDocument AS EMPLOYEEDOCUMENT ON DOCUMENT.cmis:objectId =3D EM=
PLOYEEDOCUMENT.cmis:objectId WHERE (IN_TREE('workspace://SpacesStore/89fbb2=
b2-2992-4104-9cec-cd2c15fb95e7') AND DOCUMENT.cmis:objectId IN ('workspace:=
//SpacesStore/f0e7d3e7-cb74-4993-ad61-87042ca6de72'))
>=20
> This query contains JOIN predicates because we are using aspects, support=
ed by the alfresco CMIS implementation. We use the "Alfresco OpenCMIS Exten=
sion" library (found here: http://cmis.alfresco.com:8080/alfresco-opencmis-=
extension.html) to easily add and remove aspects in our code.
>=20
> We were wondering if this is a problem with our query or if this is a bug=
 in Alfresco.
>=20
> Thanks in advance.
>=20
> -- Geert&  Mano
>=20
>=20
> _________________________________________________
>=20
>   We published a new company movie featuring YOU!
>           See http://www.aca-it.be/movie
> _________________________________________________