Mailing-List: contact dev-help@chemistry.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@chemistry.apache.org
Received-SPF: pass (nike.apache.org: domain of florian.mueller@alfresco.com
 designates 207.126.144.115 as permitted sender)
Message-ID: <4DAEAC9B.7070806@alfresco.com>
Date: Wed, 20 Apr 2011 10:51:23 +0100
From: =?UTF-8?B?RmxvcmlhbiBNw7xsbGVy?= <florian.mueller@alfresco.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
To: dev@chemistry.apache.org, g.vanheusden@aca-it.be
Subject: Re: Different result with same query but other OpenCMIS version
References: <1832895642.85647.1303292442437.JavaMail.root@itshas-sv06>
In-Reply-To: <1832895642.85647.1303292442437.JavaMail.root@itshas-sv06>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi Geert,

The query code has not been altered between 0.2.0 and 0.3.0. The CMIS 
Workbench is built around OpenCMIS. If it returns the correct results, 
so the OpenCMIS client library should return the correct results.

Is there anything else you have changed?


Cheers,

Florian


On 20/04/2011 10:40, Geert Vanheusden wrote:
> Dear,
>
> I just upgraded to OpenCMIS 0.3.0 (coming from 0.2.0-incubating) and I noticed that the same query I used before returns an incorrect result.
>
> I have a custom document type (park:document) and a park:employeeDocument aspect.
>
> When I execute the following query using OpenCMIS 0.2.0-incubating I have one document as a result (correct). If I execute the same query using OpenCMIS 0.3.0 then there are no documents returned.
>
> cmisSession.query("
> SELECT DOCUMENT.*, EMPLOYEEDOCUMENT.*
> FROM park:document AS DOCUMENT
> JOIN park:employeeDocument AS EMPLOYEEDOCUMENT
> ON DOCUMENT.cmis:objectId = EMPLOYEEDOCUMENT.cmis:objectId
> WHERE (EMPLOYEEDOCUMENT.employeeDoc:currentEmployeeName LIKE '%VANHEUSDEN%')
> ", false)
>
> I am using the alfresco-opencmis-extension 0.2 and querying against an Alfreso enterprise 3.4.
> If I execute the same query in the latest version of the OpenCMIS workbench I have also one document as a result (correct).
>
> Any ideas? Maybe a bug in OpenCMIS 0.3.0?
>
> Kind regards,
>
> Geert Vanheusden
>
>
> _________________________________________________
>
>   We published a new company movie featuring YOU!
>           See http://www.aca-it.be/movie
> _________________________________________________