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.

Alfresco Cmis Query Not Search Site Title

suayb58

Hello,Everyone.I'm trying to search the site through cmis query.But cmis query does not search the site title.cmis: title cannot find site title .I'm waiting for your help on this.

{
"query": {
"query": "SELECT * FROM st:site where (cmis:name LIKE '%PJ001%' or cmis:description LIKE '%Proje Do%')",
"language": "cmis"
},
"include": ["allowableOperations","properties"],
"fields": ["id","aspectNames", "name", "properties","allowableOperations"],
"paging": {
"maxItems": "10",
"skipCount": "0"
}
}

Find more posts tagged with

Alfresco Content Services

Comments

kintu_barot

This may be helpful to you CMIS Query to get documents with a specific aspect property value

Regards,

Kintu

ContCentric

jpotts

You say you want to search against title but I don't see it in your query. As Kintu points out, if you actually do want to search against title, you'll need to do a join because title is in the cm:titled aspect.

Here is a CMIS query that searches for sites with name, description or title like "%jtp%":

SELECT S.cmis:name, T.cm:title FROM st:site as S join cm:titled as T on S.cmisbjectId = T.cmisbjectId where (S.cmis:name LIKE '%jtp%' or T.cmis:description LIKE '%jtp%' or T.cm:title LIKE '%jtp%')

suayb58

Can this query be case sensetive?

jpotts

I believe the use of "LIKE" makes the query case-insensitive. If you use "=" instead then it becomes case-sensitive, but then you cannot use a wildcard.