NXQL query with backslash

[hgonzalez_]

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?

[bruce_Grant]

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

[hgonzalez_]

Yes, it also fails.

[Florent_Guillau]

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.

[hgonzalez_]

Thanks, I will wait for the fix.