@Override public Page<T> findAll(Predicate predicate, Pageable pageable) { Assert.notNull(pageable, "Pageable must not be null!"); final JPQLQuery<?> countQuery = createCountQuery(predicate); JPQLQuery<T> query = querydsl.applyPagination(pageable, createQuery(predicate).select(path)); return PageableExecutionUtils.getPage(query.fetch(), pageable, countQuery::fetchCount); }
@Override public Page<T> findAll(Predicate predicate, Pageable pageable) { Assert.notNull(pageable, "Pageable must not be null!"); final JPQLQuery<?> countQuery = createCountQuery(predicate); JPQLQuery<T> query = querydsl.applyPagination(pageable, createQuery(predicate).select(path)); return PageableExecutionUtils.getPage(query.fetch(), pageable, countQuery::fetchCount); }
@Override public Page<T> findAll(Predicate predicate, Pageable pageable) { Assert.notNull(pageable, "Pageable must not be null!"); final JPQLQuery<?> countQuery = createCountQuery(predicate); JPQLQuery<T> query = querydsl.applyPagination(pageable, createQuery(predicate).select(path)); return PageableExecutionUtils.getPage(query.fetch(), pageable, countQuery::fetchCount); }
@Override public Page<T> findAll(Predicate predicate, Pageable pageable) { Assert.notNull(pageable, "Pageable must not be null!"); final JPQLQuery<?> countQuery = createCountQuery(predicate); JPQLQuery<T> query = querydsl.applyPagination(pageable, createQuery(predicate).select(path)); return PageableExecutionUtils.getPage(query.fetch(), pageable, countQuery::fetchCount); }
protected Page<E> findAll(JPAQuery query, Pageable pageable) { if (pageable == null) { pageable = new QPageRequest(0, Integer.MAX_VALUE); } long total = query.clone(super.getEntityManager()).fetchCount(); JPQLQuery pagedQuery = getQuerydsl().applyPagination(pageable, query); List<E> content = total > pageable.getOffset() ? pagedQuery.fetch() : Collections.<E>emptyList(); return new PageImpl<>(content, pageable, total); }
public Page<E> findAllWithFetch(EntityPathBase<E> path, Predicate predicate,boolean distinct, Pageable pageable, QueryDslFetchJoin... joins) { if (pageable == null) { pageable = new QPageRequest(0, Integer.MAX_VALUE); } long total = createFetchQuery(path, predicate,distinct,joins).fetchCount(); JPQLQuery pagedQuery = getQuerydsl().applyPagination(pageable, createFetchQuery(path, predicate, distinct,joins)); List<E> content = total > pageable.getOffset() ? pagedQuery.fetch() : Collections.<E>emptyList(); return new PageImpl<>(content, pageable, total); }
public Page<CardCategoryLevel> findAll(Predicate predicate, Pageable pageable) { JPAQuery countQuery = createQuery(predicate); JPAQuery query = (JPAQuery) querydsl.applyPagination(pageable, createQuery(predicate));
final PageRequest fixedPage = new PageRequest(pageable.getPageNumber(), pageable.getPageSize(), fixedSort); getQuerydsl().applyPagination(fixedPage, query);
@Override public Page<MetadataColumn> linkedMetadataColumns(String dictionaryId, Pageable pageable) { QMetadataColumn qMetadataColumn = QMetadataColumn.metadataColumn; JPQLQuery<MetadataColumn> query = from(qMetadataColumn).join(qMetadataColumn.metadata).fetchJoin() .where(qMetadataColumn.dictionary.id.eq(dictionaryId)); Long total = query.fetchCount(); List<MetadataColumn> contents; if(total > pageable.getOffset()) { query = getQuerydsl().applyPagination(pageable, query); contents = query.fetch(); } else { contents = Lists.newArrayList(); } return new PageImpl<>(contents, pageable, total); } }
public Page<Metadata> searchMetadatas(Metadata.SourceType sourceType, String catalogId, String tag, String nameContains, String searchDateBy, DateTime from, DateTime to, Pageable pageable) { QMetadata qMetadata = QMetadata.metadata; QTagDomain qTagDomain = QTagDomain.tagDomain; JPQLQuery<Metadata> query; if(StringUtils.isNotEmpty(tag)) { query = from(qMetadata, qTagDomain).select(qMetadata) .where(qMetadata.id.eq(qTagDomain.domainId)) .where(qTagDomain.tag.name.eq(tag)); } else { query = from(qMetadata); } query.where(MetadataPredicate.searchList(sourceType, catalogId, null, nameContains, searchDateBy, from, to)); Long total = query.fetchCount(); List<Metadata> contents; if(total > pageable.getOffset()) { query = getQuerydsl().applyPagination(pageable, query); contents = query.fetch(); } else { contents = Lists.newArrayList(); } return new PageImpl<>(contents, pageable, total); }
public Page<Account> search(final AccountSearchType type, final String value, final Pageable pageable) { final QAccount account = QAccount.account; final JPQLQuery<Account> query; switch (type) { case EMAIL: query = from(account) .where(account.email.value.likeIgnoreCase(value + "%")); break; case NAME: query = from(account) .where(account.firstName.likeIgnoreCase(value + "%") .or(account.lastName.likeIgnoreCase(value + "%"))); break; case ALL: query = from(account).fetchAll(); break; default: throw new IllegalArgumentException(); } final List<Account> accounts = getQuerydsl().applyPagination(pageable, query).fetch(); return new PageImpl<>(accounts, pageable, query.fetchCount()); }
getQuerydsl().applyPagination(pageRequest, query);
query = getQuerydsl().applyPagination(pageable, query); contents = query.fetch(); } else {