AnsweredAssumed Answered

Howto filter documents on aspects

Question asked by plean on Mar 28, 2018

Hello,

 

As outer joins don't work with CMIS, I decided to filter documents based on its aspects. As far as I could find out is that  cmis:secondaryObjectTypeIds should be a multivalued field containing exactly this information. I have documents with P:cm:titled and documents without this aspect, so now I want to query once the first one and once the second one.

 

The problem is that the first Query does not return any document:

 

SELECT *  FROM cmis:document where 'P:cm:titled'  =  ANY cmis:secondaryObjectTypeIds

SELECT *  FROM cmis:document where ANY cmis:secondaryObjectTypeIds  IN ('P:cm:titled')

 

And the second query gives me all documents:

 

SELECT *  FROM cmis:document where ANY cmis:secondaryObjectTypeIds  NOT IN ('P:cm:titled')

SELECT *  FROM cmis:document where 'P:cm:titled'  <> ANY cmis:secondaryObjectTypeIds

 

Any suggestions?

 

Thank you.

Outcomes