This is part doesn't look good
SELECT * FROM [pb:community] WHERE ISDESCENDANTNODE('/community')
This should be
SELECT * FROM [pb:community] AS s WHERE ISDESCENDANTNODE(s, '/community')
-----Original Message-----
From: Dinesh Babu [mailto:[email protected]]
Sent: Friday, April 17, 2015 3:45 PM
To: [email protected]; [email protected]
Subject: Jackrabbit search does not find node with backslash in its name
Hi,
Jackrabbit search for a node with backslash ("\") does not work.
This is the following query that we fire which does not work SELECT * FROM
[pb:community] WHERE ISDESCENDANTNODE('/community') AND ( LOWER([jcr:title]) =
'back\slash1' )
Does anyone know how to escape a backslash to get this query working? Commonly
used methods in Text or ISO9075 does not do the trick.
Regards,
Dinesh Babu
Pitney Bowes Software
6 Hercules Way, Leavesden Park, Watford, Herts WD25 7GS
________________________________
