jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From danisevsky <danisev...@gmail.com>
Subject JCR-SQL2 query
Date Fri, 12 Oct 2012 07:51:17 GMT
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/*".

Thanks in advance.

Mime
View raw message