Less Than
SQL
SELECT CSUSER01.CSUSERNO AS CSUSERNO01
FROM CSUSER CSUSER01
WHERE (CSUSER01.SALARY < 50)
XML query API
<query alias="testGreatherThan" projectedClass="com.taleo.akirademo.entity.Candidate">
<projections>
<projection>
<field path="no"/>
</projection>
</projections>
<filterings>
<filtering>
<lessThan>
<field path="salary"/>
<integer>50</integer>
</lessThan>
</filtering>
</filterings>
</query>