topic Re: XPath Date compare does not work in Alfresco Archive

XPath Date compare does not work

rajakari — Tue, 02 Dec 2008 11:39:46 GMT

I can't get date comparisions to work when making XPath queries.Only this works: Query query = queryManager.createQuery("/jcr:root/app:company_home/cm:MCP/element(*, mcp:document)" + "[@cm:created = '2008-11-19T13:40:48.800+02:00']", Query.XPATH);

Re: XPath Date compare does not work

mikeh — Tue, 02 Dec 2008 14:05:44 GMT

Try using a range query: http://wiki.alfresco.com/wiki/Search#Range_Queries

Mike

Re: XPath Date compare does not work

rajakari — Thu, 04 Dec 2008 12:09:24 GMT

I believe the example in the link is valid for Lucene: @test\:date:[2003\-12\-16T00:00:00 TO 2003\-12\-17T00:00:00]

After several tries I can't figure out what it should be for XPath, this does not work: [@cm:created = '2001-01-01T00:00:00.000+02:00' to '2009-12-31T13:40:48.800+02:00']
It gives XPathSyntaxException.

Could somebody show me the way to do it?

Re: XPath Date compare does not work

amit_wmw — Tue, 21 Apr 2009 13:31:16 GMT

Hello,

I have a very basic question related to the above query: How to know/retrive exact time of node created? I can find year-month-date-hr-min but not beyond that. What is the meaning of 48.800+02:00 in the below query and how can I get it for my contents? Please suggest.

[@cm:created = '2008-11-19T13:40:48.800+02:00']‍

Also, if anybody has found the solution for comparing dates in XPATH using <=, >= kindly share that as well.

Thanks
Amit.

Re: XPath Date compare does not work

kpdamm — Tue, 01 Jun 2010 23:47:59 GMT

I believe this is a time stamp: 2008-11-19T13:40:48.800+02:00
Which correlates to November 19th, 2008, 1PM, 40 minutes, 48 seconds, and 800 microseconds with a GMT offset of two hours.