topic Re: XPath date comparison in Alfresco Archive

XPath date comparison

ananius — Fri, 05 May 2006 13:30:03 GMT

Hi, shouldn't alfersco support date comparison in xpath queries over jcr? At least jcr spec defines minimal set of operators for date comparing (=, !=, <, >, >=, <=).I have following simple xpath query, and it doesn't return anything although it should://app:company_home/xx:documents/xx:

Re: XPath date comparison

andy — Fri, 05 May 2006 14:04:26 GMT

Hi

Indeed it should.

The implementation uses Jaxen here. Having looked at the Jaxen API and equality operator it is treating dates as strings. No special date/time/date time treatment. You should be able to get this to work with string comparison and the ISO8601 date format.

I will report back ….

Regards

Andy

Re: XPath date comparison

lfuller — Mon, 02 Apr 2007 20:45:57 GMT

Did you find anything out Andy? I attempted to construct the query using xs:dateTime as defined in the spec. That didn't work, and the ISO8601 date format doesn't appear to work either.

Re: XPath date comparison

andy — Tue, 03 Apr 2007 09:16:20 GMT

Hi

We are using Jaxen which gives us XPath v1.0 support (more than the spec). However, internally it supports a limited set of data types when evaluating equalities. DefaultEqualityExpr does dynamic type detection for boolean, numeric and String (but not date in 1.1B8).

I think we can add the missing function, this will then do a Date.toString() comparison and should give the desired result.

Functions are registered in org.alfresco.repo.search.NodeServiceXPath if you want to give this a go.
(This should move out into a config file)

See http://issues.alfresco.com/browse/AR-1364

Regards

Andy

Re: XPath date comparison

spearson23 — Sun, 08 Jul 2007 03:46:30 GMT

what is the current status of this? is it possible to do date comparisons? (=, <, >, etc.)