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.
If dc:subjects is not set, am I correct that "quantified in predicate" (ANY dc:subjects NOT IN ('foo')) is FALSE? This is because at least one dc:subjects would need to exist that is not 'foo', right?
Yes. CMISQL ANY generates a SQL EXISTS with a subquery on the given predicate (= for NOT IN here).
ANY
EXISTS
=
NOT IN