Exists / Not Exists
SQL
SELECT CSUSER01.FIRSTNAME AS FIRSTNAME01
FROM CSUSER CSUSER01
WHERE (EXISTS
(SELECT CSUSER02.SALARY AS SALARY01 FROM CSUSER CSUSER02 WHERE 1=1))
SELECT CSUSER01.FIRSTNAME AS FIRSTNAME01
FROM CSUSER CSUSER01
WHERE NOT (EXISTS
(SELECT CSUSER02.SALARY AS SALARY01 FROM CSUSER CSUSER02 WHERE 1=1))
XML query API
<query alias="testExists" projectedClass="com.taleo.akirademo.entity.Candidate">
<projections>
<projection>
<field path="firstName"/>
</projection>
</projections>
<filterings>
<filtering>
<returnsResults>
<query alias="subQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
<projections>
<projection>
<field path="salary"/>
</projection>
</projections>
</query>
</returnsResults>
</filtering>
</filterings>
</query>
<query alias="testExists" projectedClass="com.taleo.akirademo.entity.Candidate">
<projections>
<projection>
<field path="firstName"/>
</projection>
</projections>
<filterings>
<filtering>
<not>
<returnsResults>
<query alias="subQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
<projections>
<projection>
<field path="salary"/>
</projection>
</projections>
</query>
</returnsResults>
</not>
</filtering>
</filterings>
</query>