Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\))
Subject: Re: JCR-SQL2 query
From: Lukas Kahwe Smith <mls@pooteeweet.org>
In-Reply-To: 
 <CADVrs4QpE1x-Ry8dco_gHT1Xp8Taq1Nxr=BmxRuEwSXSev6PbQ@mail.gmail.com>
Date: Fri, 12 Oct 2012 09:59:15 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <4C2A3FF2-445C-4A62-99A0-DC261E796249@pooteeweet.org>
References: 
 <CADVrs4QpE1x-Ry8dco_gHT1Xp8Taq1Nxr=BmxRuEwSXSev6PbQ@mail.gmail.com>
To: users@jackrabbit.apache.org


On Oct 12, 2012, at 9:51 , danisevsky <danisevsky@gmail.com> wrote:

> Hi,
>=20
> 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
>=20
> Select * from [nt:file] as file WHERE ISDESCENDANTNODE(file,
> [/brix:root/Data/Users/2/35935/racesPhotos/79])
>=20
> 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