You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Order by the apollo:propertyCommander property value (in descending order).
Initial data:
document1: apollo:propertyCommander - Walter M. Schirra
document2: apollo:propertyCommander - Frank F. James, II
document3: apollo:propertyCommander - James A. Lovell, Jr.
document4: apollo:propertyCommander - Eugene A. James
SELECT cmis:lastModifiedBy, cmis:objectId, cmis:lastModificationDate FROM cmis:document ORDER BY cmis:propertyCommander DESC
Query result:
document1, document3, document2, document4.