如何使用criteriaquery实现sql。
选择t.information，b.name，t.countnum from（select information，count（）as countnum from task where 1=1 group by information）t left join user b on t.information=b.information；
已完成sql选择信息，count（）as countnum from task where 1=1 group by information

CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<Tuple> query = cb.createTupleQuery();
Root<Task> root = query.from(Task.class);
List<Predicate> predicates = new ArrayList<>();
Predicate[] p = null;
if (taskSearchDTO == null) {
    p = new Predicate[predicates.size()];
} else {
    p = getSearchCeritia(taskSearchDTO, root, cb, predicates);
}
query.select(cb.tuple(root.get("Information").as(String.class), cb.count(root)));

query.where(cb.and(predicates.toArray(p)));

query.groupBy(root.get("("Information")"));