07-28-2009 04:41 PM
All capabilities of CMIS SQL are supported (except join between Types). The Alfresco FTS language may be embedded in the CMIS SQL contains() predicate.(http://wiki.alfresco.com/wiki/CMIS)
Alfresco Aspects may also be queried as if they were tables and joined to Types by ObjectId.
SELECT D.*, O.* FROM DOCUMENT AS D JOIN CM_OWNABLE AS O ON (D.ObjectId = O.ObjectId)
08-24-2009 08:43 AM
10-27-2009 10:35 AM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.