Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: Adeel Shahzad <Adeel.Shahzad@cto247.com>
To: "users@jackrabbit.apache.org" <users@jackrabbit.apache.org>
Subject: RE: Jackrabbit search does not find node with backslash in its name
Thread-Topic: Jackrabbit search does not find node with backslash in its name
Thread-Index: AdB4+5ew2XrzsQatSUSzjPbE2cawMgAHaZIwAAqBJQAACQNYIP//w/GAgABENFA=
Date: Fri, 17 Apr 2015 15:57:37 +0000
Message-ID: 
 <AD483720132ADF439AFB92294E132CDE95DAF6@TXHOUEXMB10.sisco.stewart.net>
References: 
 <2F73AE7E4C010149AB0F643C48617EF02CAB39E9@013-BR1MPN1-013.MGDPBI.global.pvt>
 <AD483720132ADF439AFB92294E132CDE95DA71@TXHOUEXMB10.sisco.stewart.net>
 <2F73AE7E4C010149AB0F643C48617EF02CAB3E00@013-BR1MPN1-013.MGDPBI.global.pvt>
 <AD483720132ADF439AFB92294E132CDE95DAAD@TXHOUEXMB10.sisco.stewart.net>
 <2F73AE7E4C010149AB0F643C48617EF02CAB3F0B@013-BR1MPN1-013.MGDPBI.global.pvt>
In-Reply-To: 
 <2F73AE7E4C010149AB0F643C48617EF02CAB3F0B@013-BR1MPN1-013.MGDPBI.global.pvt>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

This might seem strange, but you will have to escape the '\' in your node's=
 jcr:title property and not in query.

I am trying to find what the specification says for property name conventio=
n.

Thanks,
Adeel

-----Original Message-----
From: dinesh.babu@pb.com [mailto:dinesh.babu@pb.com]=20
Sent: Friday, April 17, 2015 8:01 PM
To: users@jackrabbit.apache.org
Subject: RE: Jackrabbit search does not find node with backslash in its nam=
e

Thanks Adeel.

1) I can't use Like clause, because I am looking for exact match

2) I escaped "\" by making it "\\" in the exact match query AND ( LOWER([jc=
r:title]) =3D 'back\\slash1' ). That did not bring any result.

Regards,
Dinesh Babu

Ph: +441923 279123
dinesh.babu@pb.com
www.pb.com<http://www.pb.com/>

Pitney Bowes Software
6 Hercules Way, Leavesden Park, Watford, Herts WD25 7GS

From: Adeel Shahzad [via Jackrabbit] [mailto:ml-node+s510166n4662322h48@n4.=
nabble.com]
Sent: 17 April 2015 15:56
To: Dinesh Babu
Subject: RE: Jackrabbit search does not find node with backslash in its nam=
e

Ok got you. I have done something to check this...

I added 2 properties in my node. These props are:

- test:abc\tre
- test123:abc\\tre

And I used following 3 queries to access the node (might help you):

select * from [nt:base] AS s where ISDESCENDANTNODE(s, '/content') and test=
123 like '%\\%'
above query showed desired node

select * from [nt:base] AS s where ISDESCENDANTNODE(s, '/content') and test=
 like '%\%'
above query didn't come up with any result

select * from [nt:base] AS s where ISDESCENDANTNODE(s, '/content') and test=
123 like '%\%'
above query also showed nothing

I think you might have to change the value of jcr:title i.e. escape the val=
ue there

Thanks,
Adeel

-----Original Message-----
From: [hidden email]</user/SendEmail.jtp?type=3Dnode&node=3D4662322&i=3D0> =
[mailto:[hidden email]</user/SendEmail.jtp?type=3Dnode&node=3D4662322&i=3D1=
>]
Sent: Friday, April 17, 2015 7:18 PM
To: [hidden email]</user/SendEmail.jtp?type=3Dnode&node=3D4662322&i=3D2>
Subject: RE: Jackrabbit search does not find node with backslash in its nam=
e

Thanks for your reply.

It did not work. The problem part in the query is here "AND ( LOWER([jcr:ti=
tle]) =3D 'back\slash1' ) " where title name has got a backslash in its nam=
e

Regards,
Dinesh Babu


From: Adeel Shahzad [via Jackrabbit] [mailto:[hidden email]</user/SendEmail=
.jtp?type=3Dnode&node=3D4662322&i=3D3>]
Sent: 17 April 2015 15:07
To: Dinesh Babu
Subject: RE: Jackrabbit search does not find node with backslash in its nam=
e

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=3Dnode&no=
de=3D4662320&i=3D0>]
Sent: Friday, April 17, 2015 3:45 PM
To: [hidden email]</user/SendEmail.jtp?type=3Dnode&node=3D4662320&i=3D1>; [=
hidden email]</user/SendEmail.jtp?type=3Dnode&node=3D4662320&i=3D2>
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]=
) =3D 'back\slash1' )

Does anyone know how to escape a backslash to get this query working? Commo=
nly 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 be=
low:
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 [hidden email]</user/S=
endEmail.jtp?type=3Dnode&node=3D4662322&i=3D4><mailto:[hidden email]</user/=
SendEmail.jtp?type=3Dnode&node=3D4662322&i=3D5>>
To unsubscribe from Jackrabbit, click here< NAML<http://jackrabbit.510166.n=
4.nabble.com/template/NamlServlet.jtp?macro=3Dmacro_viewer&id=3Dinstant_htm=
l%21nabble%3Aemail.naml&base=3Dnabble.naml.namespaces.BasicNamespace-nabble=
.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&b=
readcrumbs=3Dnotify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabb=
le%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________


--
View this message in context: http://jackrabbit.510166.n4.nabble.com/Jackra=
bbit-search-does-not-find-node-with-backslash-in-its-name-tp4662318p4662321=
.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.


________________________________
If you reply to this email, your message will be added to the discussion be=
low:
http://jackrabbit.510166.n4.nabble.com/Jackrabbit-search-does-not-find-node=
-with-backslash-in-its-name-tp4662318p4662322.html
To start a new topic under Jackrabbit - Users, email ml-node+s510166n510167=
h43@n4.nabble.com<mailto:ml-node+s510166n510167h43@n4.nabble.com>
To unsubscribe from Jackrabbit, click here<http://jackrabbit.510166.n4.nabb=
le.com/template/NamlServlet.jtp?macro=3Dunsubscribe_by_code&node=3D510166&c=
ode=3DZGluZXNoLmJhYnVAcGIuY29tfDUxMDE2NnwtMTUwMTI4NTUzMA=3D=3D>.
NAML<http://jackrabbit.510166.n4.nabble.com/template/NamlServlet.jtp?macro=
=3Dmacro_viewer&id=3Dinstant_html%21nabble%3Aemail.naml&base=3Dnabble.naml.=
namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.v=
iew.web.template.NodeNamespace&breadcrumbs=3Dnotify_subscribers%21nabble%3A=
email.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble=
%3Aemail.naml>

________________________________


--
View this message in context: http://jackrabbit.510166.n4.nabble.com/Jackra=
bbit-search-does-not-find-node-with-backslash-in-its-name-tp4662318p4662323=
.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.