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:
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.
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.
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)
