JCR_SQL2 | On searching special character getting InvalidQueryException

[nidhis8242823]

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

[smacdonald2008 · Accepted solution]

Read this topic -- https://wiki.apache.org/jackrabbit/EncodingAndEscaping. YOU  need to escape illegal JCR characters.

[nidhis8242823]

Thanks Scott Macdonald.