Hi,
I am using JCR_SQL2 Query and below is my query
String queryString = "select [jcr:path], [jcr:content/jcr:title] from [cq:Page] as a "
+ "where lower([jcr:content/jcr:title]) like '%"
+ term.toLowerCase()
+ "%' and [jcr:content/hideInSitemap] is null and isdescendantnode(a, '"
+ path
+ "')";
I have a test page and its jcr:title is test'test , so when i search for test'test, i am getting InvalidQueryException and on other hand if am searching test-test it does not throws any exception.
Kindly suggest how to write query to search pages with title containing special character.
Thanks & Regards,
Nidhi
Solved! Go to Solution.
Read this topic -- https://wiki.apache.org/jackrabbit/EncodingAndEscaping. YOU need to escape illegal JCR characters.
Read this topic -- https://wiki.apache.org/jackrabbit/EncodingAndEscaping. YOU need to escape illegal JCR characters.
Thanks Scott Macdonald.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies