Skip to main content
LinearGradient
LinearGradient
Level 6
October 16, 2015
Solved

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.
smacdonald2008
smacdonald2008Accepted solution
Level 10
October 16, 2015

Here is a good link for JCR SQL2:

http://www.day.com/specs/jcr/2.0/6_Query.html

View in thread

2 replies

smacdonald2008
smacdonald2008Accepted solution
Level 10
October 16, 2015

Here is a good link for JCR SQL2:

http://www.day.com/specs/jcr/2.0/6_Query.html

Translate
LinearGradient
LinearGradientAuthor
Level 6
October 16, 2015

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...