topic Re: CMIS Query with custom property issue in Alfresco Archive

CMIS Query with custom property issue

mikemars — Wed, 14 Mar 2012 14:48:38 GMT

Hi,I am running a CMIS Query against an Alfresco Labs 4.0d repository.The query uses an aspect and a custom property which is a String. The query looks likeELECT d.cmisbjectid FROM cmis:document as d join sa:myCustomAspect as g on d.cmisbjectid = g.cmisbjectid WHERE g.sa:myCustomProperty li

Re: CMIS Query with custom property issue

jpotts — Tue, 20 Mar 2012 17:14:24 GMT

Try using equals instead of like. Despite what you might think, it isn't an exact match and appears to behave more like a like.

Jeff

Re: CMIS Query with custom property issue

mikemars — Wed, 21 Mar 2012 17:00:42 GMT

Many thanks Jeff, that has worked!!

Re: CMIS Query with custom property issue

andy — Wed, 21 Mar 2012 19:40:28 GMT

Hi

You can also set the tokenisation mode for the property to "both" in the model - your field will then behave as you would expect in SQL (as cm:name does).

Andy