topic Re: CMIS - CONTAINS does not return all documents in Alfresco Archive

CMIS - CONTAINS does not return all documents

tcuser — Thu, 29 Oct 2015 12:33:39 GMT

Hi all,I'm trying to make case-insensitive queries with and I've found that the CONTAINS method to do so is not working correctly. I've got several documents:[img]https://cdn-forums.alfresco.com/sites/forums/files/2015-10-29_125526.png[/img]And the queries are working in some cases but in some other

Re: CMIS - CONTAINS does not return all documents

mrogers — Thu, 29 Oct 2015 12:51:20 GMT

Why do you think there is a case sensitivity issue?

Re: CMIS - CONTAINS does not return all documents

tcuser — Thu, 29 Oct 2015 13:56:38 GMT

Well in fact it isn't, but the problem came when I tried to make my query case-sensitive with the CONTAINS command, since LOWER or UPPER doesn't work with LIKE… but you're right, maybe I should change this post subject.

Re: CMIS - CONTAINS does not return all documents

mrogers — Thu, 29 Oct 2015 17:25:44 GMT

It could be an eventual consistency issue.

But if you are still having problems then I'm wondering if its a cross language search issue?

Re: CMIS - CONTAINS does not return all documents

tcuser — Fri, 30 Oct 2015 08:54:43 GMT

I've cleaned my database and started tomcat in English but the problem still presist.

I have this custom folder:

[img]https://cdn-forums.alfresco.com/sites/forums/files/2015-10-29_125526_0.png[/img]

I'm trying to retrieve it, and it's woirking with the LIKE query but not with the CONTAINS one:

SELECT F.cmisbjectId,F.cmis:name,F.cmisbjectTypeId FROM cmis:folder AS F JOIN cm:titled AS T ON F.cmisbjectId=T.cmisbjectId JOIN tc:expediente AS ETC ON F.cmisbjectId=ETC.cmisbjectId JOIN tc:expedienteTC AS Z ON F.cmisbjectId=Z.cmisbjectId WHERE CONTAINS(T,'cm:description:\'*sentencia*\'') AND ETC.tc:ejercicioExpediente = 2000 –> 0 results

SELECT F.cmisbjectId,F.cmis:name,F.cmisbjectTypeId FROM cmis:folder AS F JOIN cm:titled AS T ON F.cmisbjectId=T.cmisbjectId JOIN tc:expediente AS ETC ON F.cmisbjectId=ETC.cmisbjectId JOIN tc:expedienteTC AS Z ON F.cmisbjectId=Z.cmisbjectId WHERE T.cm:description LIKE '%Sentencia%' AND ETC.tc:ejercicioExpediente = 2000 –> 4 results (including this one)

I've tried to restart Alfresco with a FULL index recovery with no luck.

Re: CMIS - CONTAINS does not return all documents

tcuser — Wed, 04 Nov 2015 08:14:32 GMT

Help anyone?