Thanks for your reply. It did not work. The problem part in the query is here "AND ( LOWER([jcr:title]) = 'back\slash1' ) " where title name has got a backslash in its name
Regards, Dinesh Babu From: Adeel Shahzad [via Jackrabbit] [mailto:[email protected]] Sent: 17 April 2015 15:07 To: Dinesh Babu Subject: RE: Jackrabbit search does not find node with backslash in its name 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:[hidden email]</user/SendEmail.jtp?type=node&node=4662320&i=0>] Sent: Friday, April 17, 2015 3:45 PM To: [hidden email]</user/SendEmail.jtp?type=node&node=4662320&i=1>; [hidden email]</user/SendEmail.jtp?type=node&node=4662320&i=2> 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 ________________________________ ________________________________ If you reply to this email, your message will be added to the discussion below: http://jackrabbit.510166.n4.nabble.com/Jackrabbit-search-does-not-find-node-with-backslash-in-its-name-tp4662318p4662320.html To start a new topic under Jackrabbit - Users, email [email protected]<mailto:[email protected]> To unsubscribe from Jackrabbit, click here<http://jackrabbit.510166.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=510166&code=ZGluZXNoLmJhYnVAcGIuY29tfDUxMDE2NnwtMTUwMTI4NTUzMA==>. NAML<http://jackrabbit.510166.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> ________________________________ -- View this message in context: http://jackrabbit.510166.n4.nabble.com/Jackrabbit-search-does-not-find-node-with-backslash-in-its-name-tp4662318p4662321.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
