private void loadAssignments(final Date startDate, final Date endDate) throws SQLException {
try (Query.Result qr =
Assignment.table
.query()
.select(Assignment.table)
.join(Assignment.table.EMPLOYEE)
.where(
Employee.table.USER.eq(cx.currentUser()),
SQL.gte(Assignment.table.END_DATE, startDate),
SQL.lte(Assignment.table.START_DATE, endDate),
SQL.not(SQL.eq(Assignment.table.PAY_RATE, BigDecimal.ZERO)))
.orderBy(SQL.desc(Assignment.table.START_DATE), SQL.desc(Assignment.table.END_DATE))
.exec(cx)) {
while (qr.next()) {
assignments.add(Assignment.table.loadRec(cx, qr));
}
}
}
