You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@chemistry.apache.org by Joshy Augustine <jo...@gmail.com> on 2014/08/20 10:55:08 UTC
CMIS QL Question
Hi All,
I have a cmis:document in the ECM Repo named Fred's Document.txt.
As per the CMIS Spec, should it be possible for me to find this document
via the following query?
SELECT * FROM cmis:document where cmis:name = 'Fred\'s Document.txt'
As per my tests, the following are the queries that work for various
Repositories
Open CMIS In-Memory:
SELECT * FROM cmis:document where cmis:name = 'Fred''s Document.txt'
Alfresco 4.2:
SELECT * FROM cmis:document where cmis:name = 'Fred\'s Document.txt'
SharePoint 2013:
Both \ or ' does not appear to give me the correct result.
---
Cheers,
Joshy
Re: CMIS QL Question
Posted by Joshy Augustine <jo...@gmail.com>.
Hi Jens,
Thanks very much for your clarification.
Thanks,
Joshy
On Thu, Aug 21, 2014 at 7:54 AM, Huebel, Jens <j....@sap.com> wrote:
> Hi Joshy,
>
> The backslash escaping is required according to the spec. The double quote
> escaping is optional. You are correct that the escaping does not work
> correctly in the InMemory repository. As you do not get a parser exception
> but just no results this is a problem in the InMemory query processor. It
> seems to forget to unescape before matching the results if the string
> literal is compared to to a property. Thank You for reporting this, I will
> take a look to fix this.
>
> I cannot comment about the behaviour of the other repositories.
>
> Jens
>
>
> On 20/08/14 10:55, "Joshy Augustine" <jo...@gmail.com> wrote:
>
> >SELECT * FROM cmis:document where cmis:name = 'Fred\'s Document.txt'
>
>
--
Cheers,
Josh
Re: CMIS QL Question
Posted by "Huebel, Jens" <j....@sap.com>.
Hi Joshy,
The backslash escaping is required according to the spec. The double quote
escaping is optional. You are correct that the escaping does not work
correctly in the InMemory repository. As you do not get a parser exception
but just no results this is a problem in the InMemory query processor. It
seems to forget to unescape before matching the results if the string
literal is compared to to a property. Thank You for reporting this, I will
take a look to fix this.
I cannot comment about the behaviour of the other repositories.
Jens
On 20/08/14 10:55, "Joshy Augustine" <jo...@gmail.com> wrote:
>SELECT * FROM cmis:document where cmis:name = 'Fred\'s Document.txt'