topic date query in Alfresco Archive

date query

silenr0c — Thu, 24 Feb 2011 04:06:23 GMT

hi i am trying to do date query but not succeedeven trying to post this new topic in several days but no success to post anything, what's wrong with itFailSELECT * FROM cmis:document WHERE cmis:creationDate > TIMESTAMP '2010-06-01T00:00:00.000+00:00'SuccessSELECT * FROM cmis:document WHERE cmis:c

Re: date query

silenr0c — Thu, 24 Feb 2011 04:15:57 GMT

FYI: I try in 2 different versions
CMIS repository info ( I try in 2 different version in separate server)
Version Supported   1.0
Specification Title   CMIS Version 1.0 Committee Draft 07
Repository Id   01fc63fe-ce87-46a6-9d61-01368f11a5f8
Repository Name   Main Repository
Repository Description   [none]
Vendor Name   Alfresco
Product Name   Alfresco Repository (Community)
Product Version   3.3.0 (2765)

Version Supported   1.0
Specification Title   CMIS Version 1.0 OASIS Standard
Repository Id   01fc63fe-ce87-46a6-9d61-01368f11a5f8
Repository Name   Main Repository
Repository Description   [none]
Vendor Name   Alfresco
Product Name   Alfresco Repository (Community)
Product Version   3.4.0 (c 3335)

Re: date query

andy — Fri, 04 Mar 2011 20:26:28 GMT

Hi

There have been some bug fixes to datetime date ranges (used by the first query).
This is not yet in any community version. It will be in the next one after 3.4.

Andy

Re: date query

andy — Fri, 04 Mar 2011 20:30:49 GMT

Hi

I have tried your example on 3.4.1 E and it works as expected.

Andy

Re: date query

silenr0c — Mon, 07 Mar 2011 02:36:48 GMT

Hi Andy,

Thanks for your reply
At least I know it's not setting issue whatsoever in my server.

Then there's nothing I can do other than waiting the bug fixed in new community release later on.

Thanks again.
silenr0c