nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

date query

silenr0c

hi i am trying to do date query but not succeed
even trying to post this new topic in several days but no success to post anything, what's wrong with it

Fail
SELECT * FROM cmis:document WHERE cmis:creationDate > TIMESTAMP '2010-06-01T00:00:00.000+00:00'
Success
SELECT * FROM cmis:document WHERE cmis:creationDate = TIMESTAMP '2010-09-01T01:00:00.000+00:00'

it seems that i can't use < (less than) and > (greater than) for date comparison

Find more posts tagged with

Comments

silenr0c

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)

andy

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

andy

Hi

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

Andy

silenr0c

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