jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Conoly, Brett" <Brett.Con...@digitalinsight.com>
Subject RE: getProperty and jcr:name
Date Tue, 29 Apr 2008 20:50:07 GMT
Sounds like that may be the solution I'm actually looking for but I just
tried it with:
select jcr:name from nt:file where jcr:path LIKE '/someFolderNode/%'
ORDER BY jcr:name
And it did not sort them properly.  I also tried it with jcr:path. Any
other suggestions?
Thanks again

-----Original Message-----
From: tripod@day.com [mailto:tripod@day.com] On Behalf Of Tobias
Bocanegra
Sent: Tuesday, April 29, 2008 4:45 PM
To: users@jackrabbit.apache.org
Subject: Re: getProperty and jcr:name

oh, ok.
afaik, there are those virtual properties jcr:name and jcr:path for
this exact reason that exist in the query engine. IIRC, you can only
use them in the ORDER BY clause, if they're explicitly specified in
the select clause.

(i'm not 100% sure if i'm telling the truth here :-)

--
regards, toby



On 4/29/08, Conoly, Brett <Brett.Conoly@digitalinsight.com> wrote:
> Sorry, I'm actually trying to use the ORDER BY part of an sql query
and
>  it seems as if it only works on properties.  Ordering by names and
paths
>  seems like it may be a commonly requested function so I was hoping
there
>  may be some easy way to either make the node orderable in the sense
that
>  it can be ordered by name or path or force the name and/or path to be
>  defined as a property so that they can be ordered.
>  Currently I have to get all the nodes I want, order them, and then
get a
>  sublist out of that ordered list in order to get the desired
>  functionality.  Over rmi this is fairly slow and unneeded when there
>  should be a way to get the ORDER BY functionality working on names or
>  paths from the rmi server.
>  I'm just asking if this is possible through node configuration or
>  perhaps a function that I may have missed.
>  Thanks,
>
> Brett
>
>
>  -----Original Message-----
>  From: tripod@day.com [mailto:tripod@day.com] On Behalf Of Tobias
>  Bocanegra
>  Sent: Tuesday, April 29, 2008 4:10 PM
>  To: users@jackrabbit.apache.org
>  Subject: Re: getProperty and jcr:name
>
>  hi brett,
>  i don't quite understand your question. the 'jcr:name' and 'jcr:path'
>  properties do not exist on a node unless you set them. using
getName()
>  or getPath() is the correct way of retrieving the name or path of an
>  item.
>
>  --
>  regards, toby
>
>
>  On 4/29/08, Conoly, Brett <Brett.Conoly@digitalinsight.com> wrote:
>  > I was just writing a comparator for the jcr nodes and in my test
case
>  I
>  >  was comparing the jcr:name and jcr:path properties of the nodes.
I
>  >  realize that there's a getPath and getName function on the nodes
but
>  is
>  >  there any way to get these as properties without it throwing a
>  >  PathNotFoundException?
>  >  Thanks in advance
>

Mime
View raw message