AnsweredAssumed Answered

CMIS query with a date

Question asked by agz on May 22, 2013
Latest reply on Jan 23, 2018 by raghav
Hi all,
I have my Alfresco Community 4.0.e with Solr and I try to get documents through CMIS.

I have my custom model defines a metadata (
ged:startDate
) with a d:date type (like cmis:creationDate).

When i try to execute a query through CMIS workbench (for testing query) I'm not able to compare date:


SELECT D.*
FROM cmis:document as D
JOIN ged:cotractModel AS C ON D.cmis:objectId = C.cmis:objectId 
C.ged:startDate<TIMESTAMP '2013-05-22T13:59.54+02.00'

The workbench give me "Internal server error" :(

(The same query can be executed using
D.cmis:creationDate
instead
C.ged:startDate
)

In my Alfresco I have setted
d_dictionary.datatype.d_datetime.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateTimeAnalyser
but I have same errors.

Where is the problem?

I hope someone can helps me.
Thanks.

Outcomes