CMIS Query and custom properties

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

josekdiz

Hi everybody,

I have created a custom model, and now I'm trying to perform queries CMIS SQL to find custom contents.
This is the query I have performed:

SELECT myModel_customProperty
   FROM myModel_customContentType
   WHERE (IN_TREE('myFolder'));
‍‍‍‍‍

This query works, but now I want to find custom contents with the property in the where clause. These are
the queries that I performed, but both of them do not work:

SELECT *
   FROM myModel_customContentType
   WHERE (IN_TREE('myFolder') AND (myModel_customProperty = 'x'));
‍‍‍‍‍

SELECT *
   FROM myModel_customContentType
   WHERE (IN_TREE('myFolder') AND (myModel_customProperty LIKE 'x'));
‍‍‍‍‍

Can any one help me? I have not found so much information about CQL queries, just in CMIS standard.

Thanks in advance,
Jose.

openpj

Now Alfresco CMIS implementation support CMIS Query on Custom Content Type only on the HEAD trunk of Alfresco source code (Alfresco 3.2).
Have you tried to download the latest source code?

Hope this helps.