03-23-2022 02:02 AM
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?
08-01-2024 03:25 AM
Same question 2 years later. Does anybody have an idea on how to do that ?
08-02-2024 12:07 AM
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\'')
Explore our Alfresco products with the links below. Use labels to filter content by product module.