topic Alfresco Cmis Query Not Search Site Title in Alfresco Forum

Alfresco Cmis Query Not Search Site Title

suayb58 — Fri, 28 Dec 2018 14:27:06 GMT

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%')", "

Re: Alfresco Cmis Query Not Search Site Title

kintu_barot — Mon, 31 Dec 2018 09:26:02 GMT

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

Regards,

Kintu

ContCentric

Re: Alfresco Cmis Query Not Search Site Title

jpotts — Wed, 02 Jan 2019 23:25:46 GMT

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

Re: Alfresco Cmis Query Not Search Site Title

suayb58 — Fri, 18 Jan 2019 07:09:48 GMT

Can this query be case sensetive?

Re: Alfresco Cmis Query Not Search Site Title

jpotts — Mon, 28 Jan 2019 15:28:07 GMT

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.