Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 54B9FB4F5 for ; Wed, 4 Jan 2012 07:32:31 +0000 (UTC) Received: (qmail 94113 invoked by uid 500); 4 Jan 2012 07:32:31 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 93468 invoked by uid 500); 4 Jan 2012 07:32:12 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 93357 invoked by uid 99); 4 Jan 2012 07:32:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Jan 2012 07:32:06 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.160.42] (HELO mail-pw0-f42.google.com) (209.85.160.42) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Jan 2012 07:31:58 +0000 Received: by pbds10 with SMTP id s10so20198510pbd.1 for ; Tue, 03 Jan 2012 23:31:36 -0800 (PST) MIME-Version: 1.0 Received: by 10.68.192.70 with SMTP id he6mr4906778pbc.37.1325662296290; Tue, 03 Jan 2012 23:31:36 -0800 (PST) Received: by 10.68.190.2 with HTTP; Tue, 3 Jan 2012 23:31:36 -0800 (PST) Date: Wed, 4 Jan 2012 17:31:36 +1000 Message-ID: Subject: sort by updated / created From: Torgeir Veimo To: users@jackrabbit.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org My model has nodes with jcr:created and an optional nen:updated property, if a node is updated after creation. I'd like to sort on nen:updated, but if that property is not present, sort on the jcr:created property. I've tried ... order by @nen:updated, @jcr:created in my xpath queries, but it doesn't seem to work as expected. Is such fallback for non-existant properties not supported, or is it only supported for sql queries? Am using jackrabbit 2.3.5. -- -Tor