A.A.A.R. bugfix: Invalid column for cmis:document cmis:objectid


While getting the parent path of the Alfresco nodes, the CMIS query could contain a bug in the ‘cmis:objectid’ field. Instead of ‘cmis:objectid’ should be used ‘cmis:objectId’ (pay attention to the camel case). A new FAQ has been added to the A.A.A.R. FAQ page.

I’m investigating the context because not all the environments requests that camel case format. Until than, if you have a message below:

Failed to execute script 'classpath*:alfresco/template/webscripts/org/alfresco/cmis/queries.post.cmisquery.js’:
Invalid column for cmis:document cmis:objectid

Please modify the query under ‘/Alfresco/Staging/Utility/Set folder’s children’ as described below:

cmis:objectId as cmis_objectid,
cmis:name as cmis_name
and cmis:lastModificationDate >= TIMESTAMP ”${cmis_last_update}”
and cmis:contentStreamLength >= 0′);

Many thanks to Micheal Fraser and Hu Ting Ung for the investigation and correction. Please, don’t stop contact me making suggestions, improvement and corrections to the solution.

Francesco Corti


PDI CMIS Input plugin is now compliant to Java6 and Java7

PDI CMIS Input plugin

CMIS Input plugin for Pentaho Data Integration is now compliant to Java6 and Java7. The v1.1 release, downloadable from the Pentaho Marketplace, is ready to be used with Pentaho Data Integration v4.3, v4.4 and v5.0.

Many thanks to Adrián Cadena (fugu.ec) for the contribution with the compilation of the sources and testing with Alfresco Enterprise and Community Edition.

Download CMIS Input plugin