CMIS Query and custom properties

[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.