jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Kahwe Smith <...@pooteeweet.org>
Subject Re: JCR-SQL2 query
Date Fri, 12 Oct 2012 07:59:15 GMT

On Oct 12, 2012, at 9:51 , danisevsky <danisevsky@gmail.com> 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
mls@pooteeweet.org




Mime
View raw message