chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geert Vanheusden <g.vanheus...@aca-it.be>
Subject Problem executing JOIN query in combination with IN_TREE or IN_FOLDER
Date Tue, 01 Feb 2011 11:30:26 GMT
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/queries.post.cmisquery.js':
01010001 Selector must be specified for child constraint (IN_TREE) and join
	at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:194)
	at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)
	at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
	at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:981)
	at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)


This is caused by the following query:

SELECT DOCUMENT.*, EMPLOYEEDOCUMENT.* FROM park:document AS DOCUMENT JOIN park:employeeDocument
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: http://cmis.alfresco.com:8080/alfresco-opencmis-extension.html)
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 http://www.aca-it.be/movie
_________________________________________________

Mime
View raw message