Menu

Commit [r5731]  Maximize  Restore  History

A change to the AtomicCriteria now allows fields from the main criteria to be included in the AtomicCriteria on a aggregate object.

i.e.

select * from purchase_requests pr,parts p
where p.part = pr.part and p.cage = pr.cage
and pr.status = 'O'
and (pr.order_no = 'REF' or pr.purchase_order = 'REF' or p.nsn = 'REF' or p.stock_number = 'REF')

allowing you to add pr.order_no and pr.purchaseh_order within the same AtomicCriteria as p.nsn and p.stock_number

rkisson 2011-11-19

changed /trunk/JaffaCore/source/java/org/jaffa/persistence/AtomicCriteria.java
changed /trunk/JaffaCore/source/java/org/jaffa/persistence/Criteria.java
added /trunk/JaffaCore/source/java/org/jaffa/persistence/InnerAtomicCriteria.java
changed /trunk/JaffaCore/source/java/org/jaffa/persistence/engines/jdbcengine/querygenerator/QueryStatementHelper.java
/trunk/JaffaCore/source/java/org/jaffa/persistence/AtomicCriteria.java Diff Switch to side-by-side view
Loading...
/trunk/JaffaCore/source/java/org/jaffa/persistence/Criteria.java Diff Switch to side-by-side view
Loading...
/trunk/JaffaCore/source/java/org/jaffa/persistence/InnerAtomicCriteria.java Diff Switch to side-by-side view
Loading...
/trunk/JaffaCore/source/java/org/jaffa/persistence/engines/jdbcengine/querygenerator/QueryStatementHelper.java Diff Switch to side-by-side view
Loading...
MongoDB Logo MongoDB