Query: Select all documents where the apollo:propertyCommander property is in set {'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 NOT (apollo:propertyCommander NOT IN ('James A. Lovell, Jr.'))Query result:
document3.