topic Multiple Where Clause Predicates on Attributes w/ Multiple Values in Alfresco Archive

Multiple Where Clause Predicates on Attributes w/ Multiple Values

arbitraryname — Wed, 15 Jul 2015 14:56:55 GMT

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:asp

Re: Multiple Where Clause Predicates on Attributes w/ Multiple Values

arbitraryname — Thu, 23 Jul 2015 16:53:42 GMT

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\'')
‍‍‍