jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ard Schrijvers" <a.schrijv...@onehippo.com>
Subject RE: Using an sql query and ORDER BY
Date Mon, 28 Apr 2008 11:22:40 GMT

It might be quite well possible that jcr:name is also a property which
does not end up in the index (I am not sure though, so should test it).
But, can you try to sort on any of the properties which are part of the
node, such as, my:title , and confirm that this works


> That makes sense, even though it still runs the query, but 
> even when I order by jcr:name or nt:file it still does not 
> return an ordered list of nodes... I could just be 
> misunderstanding the query syntax but nothing seems to be 
> working.  Do I have to set a certain property on the node in 
> order to make it sortable or should the query still be working?
> SELECT * FROM nt:file WHERE jcr:path LIKE 'absNodePath %' 
> ORDER BY jcr:name
> Thanks again
> -----Original Message-----
> From: Julian Reschke [mailto:julian.reschke@gmx.de]
> Sent: Wednesday, April 23, 2008 10:20 AM
> To: users@jackrabbit.apache.org
> Subject: Re: Using an sql query and ORDER BY
> Conoly, Brett wrote:
> > Anybody...?
> As far as I understand, you can't order by jcr:path, as it's 
> a synthesized property.
> BR, Julian
> PS: which means the query parser probably should reject the query.

View raw message