topic Re: Property not available for alfresco query in Alfresco Archive

Property not available for alfresco query

mundi — Tue, 13 Aug 2013 11:35:47 GMT

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 commandsjProperties.put(accident:nbr, nombre);pjProperties.put(accident:sortieLe, cal);pjProperties.put(accident:des

Re: Property not available for alfresco query

iblanco — Tue, 13 Aug 2013 11:47:01 GMT

Not sure but… shouldn't the aspect be prefixed with "P:" ? I think alfresco maps aspects as policies because the currently implemented CMIS version does not support secondary types.

Have you tried this:
select d.cmisbjectId from cmis:document as d join P:accident:rappel as a on d.cmisbjectId = a.cmisbjectId where IN_TREE(a, 'workspace://SpacesStore/b57d9fec-87c0-42e5-ab93-b34f39490bcf') and a.accident:sortieLe = '2012-12-31T23:00:00.000Z'

Re: Property not available for alfresco query

mundi — Tue, 13 Aug 2013 12:15:12 GMT

Thanks, I've tried this but it didn't solved the issue.
Strange thing is that I'm doing queries on other properties of other apects and they work without any problem.

Re: Property not available for alfresco query

mundi — Tue, 13 Aug 2013 12:19:17 GMT

I've also tried this 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:nbr = 3‍

which also works without any issue so it seems that the problem is related to the "sortieLe" property.

Re: Property not available for alfresco query

iblanco — Wed, 14 Aug 2013 06:56:39 GMT

Have you seen this ? http://forums.alfresco.com/forum/developer-discussions/alfresco-api/cmis-query-preparation-timezone-issue-06182010-1139

Re: Property not available for alfresco query

mundi — Wed, 14 Aug 2013 07:29:51 GMT

I don't think that the date format is the problem because the error says "Unknown column/property" and other queries with dates work.
Nevertheless I tried my query with "TIMESTAMP", but: same result…

Re: Property not available for alfresco query

kaynezhang — Wed, 14 Aug 2013 08:14:00 GMT

It seems property sortieLe didn't register into cmis dictionary correctly,not format problem. Could you paste your aspect definition here?
is your aspect subtype of versionable,auditable or referenceable?

Re: Property not available for alfresco query

mundi — Wed, 14 Aug 2013 11:49:00 GMT

Here my aspect definition:

<?xml version='1.0' encoding='UTF-8'?>
<cmis:type xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="cmis:cmisTypePolicyDefinitionType">
   <cmis:id>P:accident:rappel</cmis:id>
   <cmis:localName>rappel</cmis:localName>
   <cmis:localNamespace>accident.model</cmis:localNamespace>
   <cmis:displayName>Accident Rappel Document</cmis:displayName>
   <cmis:queryName>accident:rappel</cmis:queryName>
   <cmis:description>Accident Rappel Document</cmis:description>
   <cmis:baseId>cmis:policy</cmis:baseId>
   <cmis:parentId>P:cmisext:aspects</cmis:parentId>
   <cmis:creatable>false</cmis:creatable>
   <cmis:fileable>false</cmis:fileable>
   <cmis:queryable>true</cmis:queryable>
   <cmis:fulltextIndexed>true</cmis:fulltextIndexed>
   <cmis:includedInSupertypeQuery>true</cmis:includedInSupertypeQuery>
   <cmis:controllablePolicy>false</cmis:controllablePolicy>
   <cmis:controllableACL>false</cmis:controllableACL>
   <cmis:propertyStringDefinition>
      <cmis:id>accident:destinataireRappel</cmis:id>
      <cmis:localName>destinataireRappel</cmis:localName>
      <cmis:localNamespace>accident.model</cmis:localNamespace>
      <cmis:displayName>accident:destinataireRappel</cmis:displayName>
      <cmis:queryName>accident:destinataireRappel</cmis:queryName>
      <cmis:description>accident:destinataireRappel</cmis:description>
      <cmis:propertyType>string</cmis:propertyType>
      <cmis:cardinality>single</cmis:cardinality>
      <cmis:updatability>readwrite</cmis:updatability>
      <cmis:inherited>false</cmis:inherited>
      <cmis:required>false</cmis:required>
      <cmis:queryable>true</cmis:queryable>
      <cmis:orderable>false</cmis:orderable>
   </cmis:propertyStringDefinition>
   <cmis:propertyDateTimeDefinition>
      <cmis:id>accident:sortieLe</cmis:id>
      <cmis:localName>sortieLe</cmis:localName>
      <cmis:localNamespace>accident.model</cmis:localNamespace>
      <cmis:displayName>accident:sortieLe</cmis:displayName>
      <cmis:queryName>accident:sortieLe</cmis:queryName>
      <cmis:description>accident:sortieLe</cmis:description>
      <cmis:propertyType>datetime</cmis:propertyType>
      <cmis:cardinality>single</cmis:cardinality>
      <cmis:updatability>readwrite</cmis:updatability>
      <cmis:inherited>false</cmis:inherited>
      <cmis:required>false</cmis:required>
      <cmis:queryable>true</cmis:queryable>
      <cmis:orderable>true</cmis:orderable>
   </cmis:propertyDateTimeDefinition>
   <cmis:propertyIntegerDefinition>
      <cmis:id>accident:nbr</cmis:id>
      <cmis:localName>nbr</cmis:localName>
      <cmis:localNamespace>accident.model</cmis:localNamespace>
      <cmis:displayName>accident:nbr</cmis:displayName>
      <cmis:queryName>accident:nbr</cmis:queryName>
      <cmis:description>accident:nbr</cmis:description>
      <cmis:propertyType>integer</cmis:propertyType>
      <cmis:cardinality>single</cmis:cardinality>
      <cmis:updatability>readwrite</cmis:updatability>
      <cmis:inherited>false</cmis:inherited>
      <cmis:required>false</cmis:required>
      <cmis:queryable>true</cmis:queryable>
      <cmis:orderable>true</cmis:orderable>
   </cmis:propertyIntegerDefinition>
</cmis:type>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Property not available for alfresco query

kaynezhang — Thu, 15 Aug 2013 01:16:36 GMT

It seems nothing was wrong with your aspect definition,You can set log4j.logger.org.alfresco.cmis.dictionary=debug in you log4j file,and restart your alfresco server to check whether your aspect and properties are registered correctly into cmis dictionary.