JCR SQL2 Filtering by path

Question

I'm trying to filter records where the path contains 'renditions' somewhere in the path. I have in the query NOT CONTAINS(s.*, 'renditions') but it returns records with renditions in the middle of the path but not at the end. Any ideas to eliminate all of these records? Is there a way that is faster than a full text search?

score 3 · Answer 1 · answered Aug 19 '15 at 22:03

3

I found it.

[jcr:path] NOT LIKE '%renditions%'

answered Aug 19 '15 at 22:03

Robert Harper

41
5

JCR SQL2 Filtering by path

1 Answers1