Hi,
I have slightly modified some SQL 2 queries from this page, but I cannot run them via CRX DE. Here's the query:
SELECT * FROM [cq:Page] WHERE PATH([cq:Page]) LIKE '/nodes/%'
The error message I am receiving is:
Query: SELECT * FROM [cq:Page] WHERE PATH([(*)cq:Page]) LIKE '/nodes/%'; expected: LENGTH, NAME, LOCALNAME, SCORE, LOWER, UPPER, or CAST
Any ideas why is this not working?