topic Re: CMIS predicate for unset property when searching in SOLR? in Alfresco Forum

CMIS predicate for unset property when searching in SOLR?

jecbm — Wed, 23 Mar 2022 09:02:03 GMT

When I perform a database search using CMIS, I can check if a certain property has been set or has a null value using IS NULL, i.e.

cm:myProperty IS NULL

This finds a number of nodes where the property is never initialized or has been explicitly set to null. However, when I point the same query to SOLR, it finds nothing. The data should have been indexed succesfully, so it seems I need to express my query in some other way. With AFTS I can check if the value has been set to anything with the negation of EXISTS, i.e.

NOT EXISTS:'cm:myProperty'

However, I'd rather not use AFTS. Is there any way to make this work with CMIS?

Re: CMIS predicate for unset property when searching in SOLR?

s3rg3d — Thu, 01 Aug 2024 10:25:59 GMT

Same question 2 years later. Does anybody have an idea on how to do that ?

Re: CMIS predicate for unset property when searching in SOLR?

angelborroy — Fri, 02 Aug 2024 07:07:38 GMT

In CMIS you cannot search for an unset property.

As an alternative, you can check by an unset aspect:

SELECT * FROM cmis:document WHERE not CONTAINS('ASPECT:\'cm:titled\'')