public void examples() {
List<Customer> activeCustomersAndFeedback = daoManager
.newQuery(Customer.class)
.outerJoin(Feedback.class, "fb")
.filterBy("active = ?", true)
.filterBy("fb.deleted != ?", true)
.orderBy("lastName")
.list();
}
public void sqlDrivenQueryExamples() {
/* Given a SQL (an actual SQL may be more complex):
select customer_id, first_name, last_name, active,
fb.feeback_text fb_feedback_text, fb.deleted fb_deleted
from customer c
left outer join feedback fb
on (c.customer_id = fb.customer_id)
where c.active = :activeFlag
*/
List<Customer> activeCustomersAndFeedback = daoManager
.newQuery(Customer.class)
.outerJoin(Feedback.class, "fb")
.backedBySql(simulatedComplexSQL)
.filterBy("fb.deleted != ?", true)
.assignParam("activeFlag", true) // assign parameter defined in the SQL
.orderBy("lastName")
.list();
}