cmis query over multivalued property not working

abreums — Fri, 25 Jul 2014 14:36:39 GMT

Hi, I'm using Alfresco 4.2.f and Chemistry-Alfresco-Extension 0.3 (running on Mac OS X 10.8.4, tomcat 7, Java Oracle 7)I have a multivalued property defined in an aspect:… <property name="hhhh:val"> <type>d:text</type> <multiple>true</multiple> <index enabled="

Re: cmis query over multivalued property not working

abreums — Mon, 28 Jul 2014 13:33:49 GMT

My error…

ANY is a logical OR… so,

searching using "ANY x NOT IN ('A','B','C')" would bring:
x <> 'A' OR x <> 'B' OR x <> 'C'

To achieve what I would like I need a two SELECT:
SELECT B.hhhh:val, A.cmisbjectID from hhhh:type A join hhhh:aspect B join A.cmisbjectId = B.cmisbjectId WHERE B.hhhh:val NOT IN ("original list of values")

build a list of 'hhhh:val' that would be the "negative list of hhhh:val values" = "list resulted from first SELECT" - "original list of values",
followed by:
Select * from hhh:type A join hhhh:aspect B join A.cmisbjectId = B.cmisbjectId WHERE B.hhhh:val NOT IN ("negative list of hhhh:val values")

But a two SELECT will bring performance impact in my application.
I will evaluate a different model instead of using multi-valued field.

topic cmis query over multivalued property not working in Alfresco Archive

cmis query over multivalued property not working

Re: cmis query over multivalued property not working