AnsweredAssumed Answered

search via cmis over aspect with ':' char

Question asked by pluttero on Mar 11, 2014
Latest reply on Mar 13, 2014 by pluttero
Dear all,
I'm experiencing a strange behavior while searching with CMIS, using CONTAINS() function.
I have a custom aspect ("dummyAspect"), with a string attribute ("dummyAttrib") which might contain : (colon) character. If, for example, I fill it with string "uffauffa", I find one record (correct result) issuing this query:

SELECT * FROM cp:dummyAspect  where CONTAINS('cp:dummyAttrib:\'uffa*fa\'')

If I modify the aspect from "uffauffa" to "uffa:uffa", the above query finds 0 results.
In order to find 1 record again, I must issue

SELECT * FROM cp:dummyAspect  where CONTAINS('cp:dummyAttrib:\'uffa:*fa\'')

Basically, it seems that the * wildcard does not consider the ":".
Any suggestion?
I do not get any WARNING/ERROR from alfresco logs

My environment is:
alfresco 4.2.c
I'm querying via apache chemistry workbench 0.9

Outcomes