nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

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.

Find more posts tagged with

Alfresco Content Services

Comments

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.