Or

SQL

SELECT CSUSER01.CSUSERNO AS entityKey
  FROM CSUSER CSUSER01
 WHERE ((CSUSER01.FIRSTNAME LIKE 'a%' ESCAPE '\') OR
       (CSUSER01.FIRSTNAME='Sam'))

XML query API

<query  alias="testIntersect2" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection alias="entityKey" tag="entityKey">
            <key path=""/>
        </projection>
    </projections>
    <filterings>
        <filtering>
            <or>
                <matches>
                    <field path="firstName"/>
                    <string>a*</string>
                </matches>
                <equal>
                    <field path="firstName"/>
                    <string>Sam</string>
                </equal>
            </or>
        </filtering>
    </filterings>
</query>