@Override public EndpointProfilesPageDto findByEndpointGroupId(PageLinkDto pageLink) { LOG.debug("Find endpoint profiles by endpoint group id [{}] ", pageLink.getEndpointGroupId()); EndpointProfilesPageDto endpointProfilesPageDto = new EndpointProfilesPageDto(); int lim = Integer.valueOf(pageLink.getLimit()); int offs = Integer.valueOf(pageLink.getOffset()); List<MongoEndpointProfile> mongoEndpointProfileList = find( query(new Criteria() .orOperator(where(EP_GROUP_STATE + "." + ENDPOINT_GROUP_ID) .is(pageLink.getEndpointGroupId()), where(EP_GROUP_STATE + "." + ENDPOINT_GROUP_ID) .is(pageLink.getEndpointGroupId()))) .skip(offs) .limit(lim + 1)); if (mongoEndpointProfileList.size() == (lim + 1)) { String offset = Integer.toString(lim + offs); pageLink.setOffset(offset); mongoEndpointProfileList.remove(lim); } else { pageLink.setNext(DaoConstants.LAST_PAGE_MESSAGE); } endpointProfilesPageDto.setPageLinkDto(pageLink); endpointProfilesPageDto.setEndpointProfiles(convertDtoList(mongoEndpointProfileList)); return endpointProfilesPageDto; }
int start = (currentPage - 1) * pageSize; voCommonPager.setPage(PageHelper.buildPage(query.getPageParameter(), (int) totalCount)); baseQuery.skip(start).limit(pageSize); final List<MongoAdapter> mongoAdapters = mongoTemplate.find(baseQuery, MongoAdapter.class, mongoTableName);
int start = (currentPage - 1) * pageSize; voCommonPager.setPage(PageHelper.buildPage(query.getPageParameter(), (int) totalCount)); baseQuery.skip(start).limit(pageSize); final List<MongoAdapter> mongoAdapters = mongoTemplate.find(baseQuery, MongoAdapter.class, mongoTableName);
baseQuery.skip(start).limit(pageSize); final List<MongoAdapter> mongoAdapters = mongoTemplate.find(baseQuery, MongoAdapter.class, mongoTableName);
where(EP_GROUP_STATE + "." + ENDPOINT_GROUP_ID) .is(pageLink.getEndpointGroupId()))); query.skip(offs).limit(lim + 1); query.fields() .include(DaoConstants.PROFILE)
Criteria criteria = Criteria.where("question").regex(questionPattern, "i"); Query query = Query.query(criteria); query.limit(getLimit()); query.skip(getSkip()); return mongoOperations.find(query, Question.class);
private List<ApiDoc> findAllOldHeadRevisions(String clientId, String apiId) { return mongoOperations.find(createAllHeadRevisionQuery(clientId, apiId).skip(1), ApiDoc.class); }
/** * */ @Override public List<T> getEntities(int page, int pageSize) { Query query = new Query(); query.limit(pageSize); if(page > 1) { query.skip((page - 1) * pageSize); } return this.mongoTemplate.find(query, this.entityClass); }
@Override public List<T> getEntities(int page, int pageSize) { Query query = new Query(); query.limit(pageSize); if(page > 1) { query.skip((page - 1) * pageSize); } return this.mongoTemplate.find(query, this.entityClass); }
@Override public List<ImportInfo> findRelatedToUser(String login, Collection<String> pbnIds, int limit, int skip) { Query query = relatedToUserQuery(login, pbnIds) .limit(limit) .skip(skip); return find(query); }
query.skip(pageIndex * pageSize); query.limit(pageSize);
@SuppressWarnings("unchecked") @Override public List<T> doInTransaction(TransactionStatus status) { if (firstResult >= 0) { query.skip(firstResult); } if (maxResults > 0) { query.limit(maxResults); } List<? extends T> entities = getMongoTemplate().find(query, clazz); if (mergeMode != null) { entities = merge(entities, mergeMode); } return (List<T>) entities; } });
@Override public List<Log> findByTestItemRef(String itemRef, int limit, boolean isLoadBinaryData) { if (itemRef == null || limit <= 0) { return new ArrayList<>(); } Query query = query(where(ITEM_REFERENCE).is(itemRef)).with(SORT_DESC_LOG_TIME); if (!isLoadBinaryData) { query.fields().exclude(BINARY_CONTENT); } long count = mongoTemplate.count(query, Log.class); long max = Math.max(0, count - limit); if (max > 0) { query.skip((int) max); } return mongoTemplate.find(query, Log.class); }
private Query mongoQuery(EventQuery query) { return mongoQueryForCount(query) .with(new Sort(Direction.ASC, PROPERTY_TIMESTAMP)) .skip(query.getSkip()) .limit(query.getLimit()); }
@Override @RequiresServiceRole(roleName="READ") public List<CollectionData> listAllCollections(int skip, int limit) { Query query = new Query(Criteria.where(F_COLLECTION_TYPE).is(CollectionTypes.USERCOLLECTION.getTypeName())).skip(skip).limit(limit); List<ElementCollection> items = mongoTemplate.find(query, ElementCollection.class, mongoCollectionName); return convert(items); }
@Override @RequiresServiceRole(roleName = "READ") public List<CollectionContentData> listAllCollectionContents(int skip, int limit) { Query query = new Query(Criteria.where(F_COLLECTION_TYPE).is(CollectionTypes.USERCOLLECTION.getTypeName())).skip(skip).limit(limit); List<ElementCollection> items = mongoTemplate.find(query, ElementCollection.class, mongoCollectionName); return extractsCollectionDocumentData(items); }
q.skip(limit.getOffset()); q.limit(limit.getCount());
entities = mongo.find(query.skip(page * pageSize).limit(pageSize), entityClass); } else { qFactory.completeQueryWithOrdering(query, queryComponent, context);
result.skip(query.getSkip()).limit(query.getLimit());