/** * Sets the order by expression in descending order of createdAt column. */ default CriteriaQuery<T> lastCreated(Integer limit) { return lastCreated().limit(limit); }
/** * Sets the order by expression in descending order of updatedAt column. */ default CriteriaQuery<T> lastUpdated(Integer limit) { return lastUpdated().limit(limit); }
@Instrument public static <T extends Model> List<T> first(int num) { Args.assertTrue(num > 0,"num must be > 0"); return (List<T>)query().orderByIdAsc().limit(num).list(); }
@Instrument public static <T extends Model> List<T> last(int num) { Args.assertTrue(num > 0,"num must be > 0"); return (List<T>)query().orderByIdDesc().limit(num).list(); }
List<Record> totalExpanded = expandQuery.limit(ac.getExpandLimit() + 1).list(); if (totalExpanded.size() > ac.getExpandLimit()) { throw new BadRequestException("Expanded records of '" + rp.getName() + "' exceed max limit " + ac.getExpandLimit());
protected void init() { log.info("Finding the max value of field '{}' at entity '{}'...", fm.getFieldName(), em.getEntityName()); Object maxValue = dao.createCriteriaQuery(em) .select(fm.getFieldName()) .limit(1) .orderBy(fm.getFieldName() + " desc") .scalarValueOrNull(); log.info("Max value : {}", maxValue); if(null != maxValue) { this.maxValue = maxValue; } changesQuery = dao.createCriteriaQuery(em, resultClass) .where(fm.getFieldName() + " > :maxValue") .limit(limit) .orderBy(fm.getFieldName() + " asc"); }
CriteriaQuery<Record> expandQuery = dao.createCriteriaQuery(rp.getTargetEntityName()).limit(ac.getExpandLimit() + 1);