cancel
Showing results for 
Search instead for 
Did you mean: 

CMIS predicate for unset property when searching in SOLR?

jecbm
Champ on-the-rise
Champ on-the-rise

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?

2 REPLIES 2

s3rg3d
Champ on-the-rise
Champ on-the-rise

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

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\'')
Hyland Developer Evangelist