As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
There is a bug in sql fragments with id sql_select_byDynamicQuery defined in metadata-query-common-SqlMap.xml file
text highlighted should be ${item.alias}.${item.fieldName} IS NULL instead of ${item.alias}.${item.fieldName} IS NOT NULL
Thanks for raising this issue.
I've created a JIRA ticket to address the problem:
https://alfresco.atlassian.net/browse/MNT-23097