// find orders and their customersList<Order> list = Ebean.find(Order.class) .join("customer") .orderBy("id") .findList();
// sort by customer name ascending, then by order shipDate // ... then by the order status descendingEbean.sort(list, "customer.name, shipDate, status desc");
// sort by customer name descending (with nulls low) // ... then by the order idEbean.sort(list, "customer.name desc nullsLow, id");
Fixed in HEAD.
List list = Ebean.find(MetaQueryStatistic.class).findList();
long nowMinus24Hrs = System.currentTimeMillis() -24*(1000*60*60);
List list2 = Ebean.filter(MetaQueryStatistic.class) .sort("avgTimeMicros desc") .gt("executionCount", 0) .gt("lastQueryTime", nowMinus24Hrs) .eq("autofetchTuned", true) .maxRows(10) .filter(list);
Home