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: Using an sql query and ORDER BY
Date Wed, 23 Apr 2008 14:30:57 GMT
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.

Mime
View raw message