In

SQL

CSUSER01.CSUSERNO AS entityKey
FROM CSUSER CSUSER01
WHERE (CSUSER01.CSUSERNO IN (SELECT CSUSER02.CSUSERNO AS entityKey
                             FROM CSUSER CSUSER02
                             WHERE (CSUSER02.FIRSTNAME LIKE 's%' ESCAPE '\')))

SELECT CSUSER01.CSUSERNO AS entityKey
FROM CSUSER CSUSER01
WHERE (CSUSER01.CSUSERNO IN (1, 2, 3))

XML query API

<query alias="testIncludedIn" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection alias="entityKey" tag="entityKey">
            <key path=""/>
        </projection>
    </projections>
    <filterings>
        <filtering>
            <includedIn>
                <field path="no"/>
                <query alias="candidateSubQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
                    <projections>
                        <projection alias="entityKey" tag="entityKey">
                            <key path=""/>
                        </projection>
                    </projections>
                    <filterings>
                        <filtering>
                            <matches>
                                <field path="firstName"/>
                                <string>s*</string>
                            </matches>
                        </filtering>
                    </filterings>
                </query>
            </includedIn>
        </filtering>
    </filterings>
</query>

<query alias="testIncludedIn" projectedClass="com.taleo.akirademo.entity.Candidate">
  <projections>
    <projection alias="entityKey" tag="entityKey">
      <key path=""/>
    </projection>
  </projections>
  <filterings>
    <filtering>
      <includedIn>
        <field path="no"/>
        <list>
          <integer>1</integer>
          <integer>2</integer>
          <integer>3</integer>
        </list>
      </includedIn>
    </filtering>
  </filterings>
</query>