gistfile1.java

    protected CriteriaQuery<LoginAggregationImpl> buildFindLoginAggregationsByDateRangeQuery(final CriteriaBuilder cb) {
        final CriteriaQuery<LoginAggregationImpl> criteriaQuery = cb.createQuery(LoginAggregationImpl.class);
        
        final Root<DateDimensionImpl> root = criteriaQuery.from(DateDimensionImpl.class);
        final CollectionJoin<DateDimensionImpl, LoginAggregationImpl> loginAggrJoin = root.join(DateDimensionImpl_.loginAggregations, JoinType.LEFT);
        
        criteriaQuery.select(loginAggrJoin);
        criteriaQuery.where(
                cb.and(
                        cb.between(root.get(DateDimensionImpl_.date), this.startDate, this.endDate),
                        cb.equal(loginAggrJoin.get(LoginAggregationImpl_.interval), this.intervalParameter),
                        cb.equal(loginAggrJoin.get(LoginAggregationImpl_.aggregatedGroup), this.aggregatedGroupParameter)
                )
        );
        criteriaQuery.orderBy(cb.desc(root.get(DateDimensionImpl_.date)));
        
        return criteriaQuery;
    }