AnsweredAssumed Answered

CMIS query using IN_TREE and multi-value property

Question asked by andrewlove on Apr 4, 2019
Latest reply on Apr 5, 2019 by 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?

Outcomes