topic Re: Like predicate in CMIS query in Alfresco Forum

Like predicate in CMIS query

udayakumar_p — Mon, 22 Jan 2018 17:12:05 GMT

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.

Re: Like predicate in CMIS query

cesarista — Tue, 23 Jan 2018 11:03:09 GMT

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.

Re: Like predicate in CMIS query

udayakumar_p — Tue, 23 Jan 2018 18:32:02 GMT

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%'

Re: Like predicate in CMIS query

cesarista — Thu, 25 Jan 2018 09:06:34 GMT

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.

Re: Like predicate in CMIS query

deepak_talape — Fri, 26 May 2023 13:38:14 GMT

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

Try this way. It worked for me.