AnsweredAssumed Answered

Property not available for alfresco query

Question asked by mundi on Aug 13, 2013
Latest reply on Aug 14, 2013 by mundi
Hello,

I've created the aspect accident:Rappel which has the properties "accident:nbr", "accident:sortieLe" and "accident:destinataireRappel".
I can set/create the properties with the commands:
pjProperties.put(accident:nbr, nombre);
pjProperties.put(accident:sortieLe, cal);
pjProperties.put(accident:destinataireRappel, destinataireRappel);
alfrescoFacade.addAspectToDocument(alfrescoDocument, pjProperties, AlfrescoFacade.ASPECT_ACCIDENT_RAPPEL);

I can also read them out with:
BigInteger nombre = alfrescoDocument.getPropertyValue(accident:nbr);
String destinataire = alfrescoDocument.getPropertyValue(accident:destinataireRappel);
GregorianCalendar calendar = alfrescoDocument.getPropertyValue(accident:sortieLe);

without any problems at all.

But if I try to execute the following query:
select d.cmis:objectId from cmis:document as d join accident:rappel as a on d.cmis:objectId = a.cmis:objectId where IN_TREE(a, 'workspace://SpacesStore/b57d9fec-87c0-42e5-ab93-b34f39490bcf') and a.accident:sortieLe = '2012-12-31T23:00:00.000Z'

I get the following error:
SEVERE: org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Unknown column/property accident:sortieLe


Does anyone knows why this is the case?

Outcomes