topic Re: NXQL query with backslash in Nuxeo Forum

NXQL query with backslash

hgonzalez_ — Thu, 11 Oct 2012 11:29:02 GMT

I am trying to execute this query with CoreSession:

CoreSession.query( "select * from Document where dc:title = 'document\' and ecm:currentLifeCycleState <> 'deleted'" )

The \ is making the query crash. If I put the \ in any other position than at the end it works. I also have tried to escape the title value with NXQLQueryBuilder.prepareStringLiteral() with it doesn't do anything. Any idea about how to execute this query or could be a Nuxeo bug?

Re: NXQL query with backslash

bruce_Grant — Thu, 11 Oct 2012 14:40:06 GMT

Have you tried a double backslash just before the single quote?

Re: NXQL query with backslash

hgonzalez_ — Thu, 11 Oct 2012 14:57:52 GMT

Yes, it also fails.

Re: NXQL query with backslash

Florent_Guillau — Thu, 18 Oct 2012 16:15:02 GMT

Thanks for the report, it's a bug in the parser. A ticket has been entered: NXP-10340. You can Watch the ticket to be notified when a fix is done.

Re: NXQL query with backslash

hgonzalez_ — Thu, 18 Oct 2012 16:25:56 GMT

Thanks, I will wait for the fix.