You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Select all documents that has the apollo:propertyCommander property is NOT NULL.
Initial data:
document1: apollo:propertyCommander - Walter M. Schirra
document2: apollo:propertyCommander -
document3: apollo:propertyCommander - James A. Lovell, Jr.
document4: apollo:propertyCommander -
SELECT * FROM cmis:document WHERE apollo:propertyCommander is NOT NULL
Query result:
document1, document3.