CMIS query using IN_TREE and multi-value property

andrewlove

I am trying to query an Alfresco 5.2 repo using cmis-strict in the node browser.

I have 5 documents in a folder tree.

2 of those 5 documents have a multi-value property accountreference = 1927615 and a single value property crmindex = X1943G;.UL

Example 1

SELECT * FROM figaro:basetype WHERE  IN_TREE('06080482-d235-4dec-bf7b-4e6027e88aab')‍

Expected result = 5 documents

Actual result = 5 documents

Example 2

SELECT * FROM figaro:basetype WHERE  '1927615' = ANY figaro:accountreference‍

Expected result = 2 documents

Actual result = 2 documents

Example 3

SELECT * FROM figaro:basetype WHERE figaro:crmindex='X1943G;.UL'

Expected result = 2 documents

Actual result = 2 documents

Example 4

SELECT * FROM figaro:basetype WHERE  IN_TREE('06080482-d235-4dec-bf7b-4e6027e88aab') AND figaro:crmindex='X1943G;.UL'

Expected result = 2 documents

Actual result = 2 documents

Example 5

SELECT * FROM figaro:basetype WHERE '1927615' = ANY figaro:accountreference AND figaro:crmindex='X1943G;.UL'

Expected result = 2 documents

Actual result = 2 documents

Example 6

SELECT * FROM figaro:basetype WHERE  IN_TREE('06080482-d235-4dec-bf7b-4e6027e88aab') AND '1927615' = ANY figaro:accountreference‍

Expected result = 2 documents

Actual result = 0 documents

THE PROBLEM

Using an AND in a WHERE clause that uses IN_TREE and a multi-value property returns zero results.

Does anyone have any ideas about this?

angelborroy

I've tried a similar approach with Alfresco 6.1 and Search Services 1.3.0.1 and it works for me.

SELECT * 
FROM figaro:basetype 
WHERE IN_TREE('e416ed7a-bb59-4805-ac86-aa6cbdcc4c9e') AND 
      '1927615' = ANY figaro:accountreference‍‍‍‍‍‍‍

Upgrading is an option?