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"
}
}

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