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?
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\'')
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.