List of all functions supported by CQ5 in SQL2 queries

Hi,

Where can I get the list of all functions that CQ5 supports in SQL2 queries? In particular, is UPPER (to convert a string to upper case) supporter?

If not, how can a case insensitive equality condition be written?

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by smacdonald2008

Here is a good link for JCR SQL2:

Level 6

Looks like UPPER/LOWER are actually supported, but only on the left hand sand of a where condition equality.

smacdonald2008Accepted solution

Level 10

Here is a good link for JCR SQL2:

Sign up