I am trying to use an 'IN' clause with Magnolia with JCR-SQL2:
SELECT * FROM [mgnl:page]
WHERE [mgnl:template] IN (
"context:pages/template-type-1",
"context:pages/template-type-2"
)
However I'm receiving this error:
SELECT * FROM [mgnl:page]
WHERE [mgnl:template] IN(*)("context:pages/template-type-1","context:pages/template-type-2");
expected: ., =, <>, <, >, <=, >=, LIKE, IS, NOT
Is this caused by the fact my implementation of the JCR does not support the IN clause?