topic Re: search via cmis over aspect with ':' char in Alfresco Archive

search via cmis over aspect with ':' char

pluttero — Tue, 11 Mar 2014 12:04:08 GMT

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 res

Re: search via cmis over aspect with ':' char

kaynezhang — Wed, 12 Mar 2014 03:07:10 GMT

you should escape character ":",like following


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

Re: search via cmis over aspect with ':' char

pluttero — Thu, 13 Mar 2014 23:35:20 GMT

Hi kaynezhang,
the query with ":" works, my problem is when ":" is inside the value, and I'm querying with
SELECT * FROM cp:dummyAspect where CONTAINS('cp:dummyAttrib:\'uffa*fa\'')
I would expect it to find values like "uffa:uffa" while it does not.
Thank you