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:dinesh.b...@pb.com] Sent: Friday, April 17, 2015 3:45 PM To: users@jackrabbit.apache.org; d...@jackrabbit.apache.org 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 ________________________________