Like predicate in CMIS query

[udayakumar_p]

Does alfresco support like predicate in CMIS query.

I have a query something like select * from cmis:document where cmisbjectTypeId like '%sometext%'.

This query throws cmisruntimeexception in the code and throws an error in the cmis workbench.

Attached error below.

[cesarista]

Hi:

Predicates and LIKES are possible in CMIS-SQL, but cmisbjectTypeId is in fact your content type, usually cmis:document or a custom type.

Regards.

--C.

[udayakumar_p]

Hi,

Thanks for the reply. I didnt get what you have said. I was saying LIKE predicate does not work for cmisbjectTypeId as in the below query.

select * from cmis:document where cmisbjectTypeId like '%sometext%'

[cesarista]

Sure, for me it's the same behaviour with this CMIS query.

I only wanted to note that you can select from your document types ("cmisbjectTypeId") in the from part

SELECT * FROM my:cars

http://alfrescoblog.com/2014/07/12/alfresco-cmis-tutorial/ 

Query Examples - Apache Chemistry Samples 

Regards.

--C.

[deepak_talape]

select * from cmis:document where cmis:name LIKE '%sometext'

Try this way. It worked for me.