5.4.1.5.2. Find document by several constraints

Warning

You are looking at documentation for an older release. Not what you want? See the current release documentation.

Query: Select all documents where apollo:propertyBooster is 'Saturn V' and apollo:propertyCommander is Frank F. Borman, II or James A. Lovell, Jr.

Initial data:

SELECT * FROM cmis:document WHERE apollo:propertyBooster = 'Saturn V' AND (apollo:propertyCommander = 'Frank F. Borman, II' OR  apollo:propertyCommander = 'James A. Lovell, Jr.')

Query result:

Copyright ©. All rights reserved. eXo Platform SAS
blog comments powered byDisqus