You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Select all documents where the apollo:propertyCommander property is not in set {'Walter M. Schirra', 'James A. Lovell, Jr.'}.
Initial data:
document1: apollo:propertyCommander - Walter M. Schirra
document2: apollo:propertyCommander - Frank F. Borman, II
document3: apollo:propertyCommander - James A. Lovell, Jr.
document4: apollo:propertyCommander - Eugene A. Cerna
SELECT * FROM cmis:document WHERE apollo:PropertyCommander NOT IN ('Walter M. Schirra', 'James A. Lovell, Jr.')Query result:
document2, document4.