From users-return-9534-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Fri Nov 07 12:44:03 2008 Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 96407 invoked from network); 7 Nov 2008 12:44:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Nov 2008 12:44:03 -0000 Received: (qmail 64980 invoked by uid 500); 7 Nov 2008 12:44:08 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 64961 invoked by uid 500); 7 Nov 2008 12:44:08 -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 64950 invoked by uid 99); 7 Nov 2008 12:44:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Nov 2008 04:44:08 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of aklimets@day.com designates 207.126.148.181 as permitted sender) Received: from [207.126.148.181] (HELO eu3sys201aog001.obsmtp.com) (207.126.148.181) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 07 Nov 2008 12:42:48 +0000 Received: from source ([209.85.198.247]) by eu3sys201aob001.postini.com ([207.126.154.11]) with SMTP; Fri, 07 Nov 2008 12:43:30 UTC Received: by rv-out-0708.google.com with SMTP id k29so1092507rvb.4 for ; Fri, 07 Nov 2008 04:43:27 -0800 (PST) Received: by 10.141.153.17 with SMTP id f17mr1749984rvo.99.1226061807911; Fri, 07 Nov 2008 04:43:27 -0800 (PST) Received: by 10.140.144.3 with HTTP; Fri, 7 Nov 2008 04:43:27 -0800 (PST) Message-ID: Date: Fri, 7 Nov 2008 13:43:27 +0100 From: "Alexander Klimetschek" To: users@jackrabbit.apache.org Subject: Re: SYSDATE() or NOW() concept in JCR query? In-Reply-To: <1226057417.22288.20.camel@c-pweighill-smith.uk.volantis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <0b6301c93ffe$ba950060$2fbf0120$@co.uk> <1226057417.22288.20.camel@c-pweighill-smith.uk.volantis.com> X-Virus-Checked: Checked by ClamAV on apache.org Hi! No, this function is not supported. The XPath defined by JCR is only a subset of XPath 1.0 and the only functions that are required are jcr-specifc (jcr:like, jcr:contains, jcr:deref, jcr:score and some of the Jackrabbit search extensions, such as rep:similar [1]). See also section 6.6.5 and 6.6.6 of the JSR-170 spec [2]. JCR 2.0 will no longer have XPath out of the box, but a java query model (JCR-JQOM). This means there will most likely be a generic XPath to JQOM converter that could be more easily and separately maintained and support such simple functions (as this only means to replace the current-dateTime() with the date value). For now you could do either do it manually in your Java code or, if you want to manually enter queries, you could write a simple wrapper that simply replaces the "current-dateTime()" string with the value of the current date. (I know, this solution won't work for all functions...) [1] http://wiki.apache.org/jackrabbit/Search [2] http://jcp.org/en/jsr/detail?id=170 Regards, Alex On Fri, Nov 7, 2008 at 12:30 PM, Phil Weighill-Smith wrote: > XPath 2.0 has a current-dateTime() function, but don't know if it's > available in Jackrabbit's implementation. > > Phil :n) > > On Thu, 2008-11-06 at 10:59 +0000, sbarriba wrote: > >> Hi all, >> >> We want to be able to query a set of nodes that have a date property which >> is earlier than the current date. >> >> >> >> Is there a function facility within JCR SQL or XPath which will be replaced >> with the current time/date? >> >> >> >> I can do it by creating a literal date in Java to achieve. >> >> xpathquery "/jcr:root/home/entries//element(*, >> acm:BlogEntry)[@acm:publishdate < >> xs:dateTime(\'2008-11-05T00:00:00.000+01:00\')]" >> >> >> >> .but I'd rather simply do.. >> >> xpathquery "/jcr:root/home/acmenodes//element(*, >> acm:BlogEntry)[@acm:publishdate < sysdate()]" >> >> >> >> All help appreciated. >> >> Regards, >> >> Shaun >> >> >> >> >> > -- Alexander Klimetschek alexander.klimetschek@day.com