AnsweredAssumed Answered

CMIS - CONTAINS does not return all documents

Question asked by tcuser on Oct 29, 2015
Latest reply on Nov 4, 2015 by tcuser
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 others they're not:

SELECT F.cmis:name, T.cm:description FROM cmis:document AS F JOIN cm:titled AS T ON F.cmis:objectId=T.cmis:objectId WHERE CONTAINS(T,'cm:description:\'*Asdf*\'') – 2 results (OK)
SELECT F.cmis:name, T.cm:description FROM cmis:document AS F JOIN cm:titled AS T ON F.cmis:objectId=T.cmis:objectId WHERE CONTAINS(T,'cm:description:\'*asdf*\'') – 2 results (OK)
SELECT F.cmis:name, T.cm:description FROM cmis:document AS F JOIN cm:titled AS T ON F.cmis:objectId=T.cmis:objectId WHERE CONTAINS(T,'cm:description:\'*Hola*\'') – 0 results (KO)
SELECT F.cmis:name, T.cm:description FROM cmis:document AS F JOIN cm:titled AS T ON F.cmis:objectId=T.cmis:objectId WHERE CONTAINS(T,'cm:description:\'*hola*\'') – 0 results (KO)
SELECT F.cmis:name, T.cm:description FROM cmis:document AS F JOIN cm:titled AS T ON F.cmis:objectId=T.cmis:objectId WHERE CONTAINS(T,'cm:description:\'*Sentencia*\'') – 0 results (KO)
SELECT F.cmis:name, T.cm:description FROM cmis:document AS F JOIN cm:titled AS T ON F.cmis:objectId=T.cmis:objectId WHERE CONTAINS(T,'cm:description:\'*sentencia*\'') – 0 results (KO)

Is there anything I'm missing??

Thank you!!

Attachments

Outcomes