On Oct 12, 2012, at 9:51 , danisevsky <[email protected]> wrote: > Hi, > > could someone please help me with JCR-SQL2 query? I would like to do > find out count of all files (photos) which are in some folder > hierarchy. This query is almost what I need > > Select * from [nt:file] as file WHERE ISDESCENDANTNODE(file, > [/brix:root/Data/Users/2/35935/racesPhotos/79]) > > But I need to exclude all files which are on path "*/imported/small/*".
could be tricky. afaik Jackrabbit hasnt implemented the PATH() dynamic operand. and while we are at it .. it also doesnt support a COUNT() :( ModeShape supports PATH, but also doesnt cover COUNT: https://docs.jboss.org/author/display/MODE/JCR-SQL2#JCR-SQL2-Pseudocolumns regards, Lukas Kahwe Smith [email protected]
