JBoss.orgCommunity 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:
document1: apollo:propertyBooster - Saturn 1B, apollo:propertyCommander - Walter M. Schirra
document2: apollo:propertyBooster - Saturn V, apollo:propertyCommander - Frank F. Borman, II
document3: apollo:propertyBooster - Saturn V, apollo:propertyCommander - James A. Lovell, Jr.
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:
document2 and document3.