Multiple Where Clause Predicates on Attributes w/ Multiple Values

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

arbitraryname

Hi Everyone,

I have a query I am trying to execute via CMIS, which queries on a attribute with multiple values.

My query is like this so far (note we alias aspects as their name to ease the generation of queries in code)

SELECT *


 FROM namespace:type AS primary JOIN namespace:aspectA AS P:namespace:aspectA ON primary.cmis:objectId=P:namespace:aspectA.cmis:objectId 

WHERE 

'myValue' = ANY P:namespace:aspectA.namespace:RepeatingAttribute
‍‍‍‍‍‍‍‍‍‍

Which is working great.

But when I try to add ANDs and ORs everything breaks down.

I know one code has 2 of my values but this does not work and returns no results and no errors. Just 0 results

SELECT *


 FROM namespace:type AS primary JOIN namespace:aspectA AS P:namespace:aspectA ON primary.cmis:objectId=P:namespace:aspectA.cmis:objectId 

WHERE 

'myValue' = ANY P:namespace:aspectA.namespace:RepeatingAttribute

AND


'myValue2' = ANY P:namespace:aspectA.namespace:RepeatingAttribute

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

When I run that same query but with an OR as the logic between my predicates, I get 15 results. However, if I query on myValue I get 1, and myValue2 returns 19. I have no idea what the intersection/distinctness could be doing to create that set of 15.

Is this just not supported? What is the logic here? And can I work around this at all?

FYI I am issuing these with CMIS WorkBench, and our code is using Apache Chemistry as well.

arbitraryname

It appears this is only achievable via contains

By using ANDs and ORs between these style predicates, this works consistently.

contains(alias, 'namespace:multiValueField:\'searchString\'')
‍‍‍