@Override public Query setOffset(int offset) { this.query.setOffset(offset); return this; }
@Override public Query setOffset(int offset) { return getWrappedQuery().setOffset(offset); }
/** * Fetches the next 'page' of results from the database. */ private void fetchNextResults() { try { // We use basic pagination (absolute offset) because we don't expect the database to change too much while // the synchronization takes place. Also, the database is used as the reference store, meaning that we // update the Solr index to match the database, not the other way around. results = getQuery().setWiki(wiki).setOffset(offset).execute(); offset += LIMIT; } catch (QueryException e) { results = Collections.emptyList(); logger.error("Failed to query the database.", e); } }
query.setOffset(start); query.setLimit(nb); query.bindValues(values);
private List<String> runQuery(String queryString, String formattedInput, int resultsLimit) { Query query = null; List<String> queryResults = null; try { query = this.qm.createQuery(queryString, Query.XWQL); if (resultsLimit > 0) { query.setLimit(resultsLimit); query.setOffset(0); } if (StringUtils.isNotBlank(formattedInput)) { query.bindValue(UsersAndGroups.INPUT_PARAMETER, formattedInput); } queryResults = query.execute(); } catch (QueryException e) { this.logger.error("Error while performing query: [{}] ", queryString, e.getMessage()); return Collections.emptyList(); } return queryResults; }
@Override public List<Event> getRecentPersonalMessages(DocumentReference author, int limit, int offset) { List<Event> result = new ArrayList<Event>(); try { Query q = this.qm.createQuery( "where event.application = 'MessageStream' and event.type = 'personalMessage'" + " and event.user = :user order by event.date desc", Query.XWQL); q.bindValue("user", this.serializer.serialize(author)); q.setLimit(limit > 0 ? limit : 30).setOffset(offset >= 0 ? offset : 0); result = this.stream.searchEvents(q); } catch (QueryException ex) { LOG.warn("Failed to search personal messages: {}", ex.getMessage()); } return result; }
@Override public List<Event> getRecentMessagesForGroup(DocumentReference group, int limit, int offset) { List<Event> result = new ArrayList<Event>(); try { Query q = this.qm.createQuery( "where event.application = 'MessageStream' and event.type = 'groupMessage'" + " and event.stream = :group order by event.date desc", Query.XWQL); q.bindValue("group", this.serializer.serialize(group)); q.setLimit(limit > 0 ? limit : 30).setOffset(offset >= 0 ? offset : 0); result = this.stream.searchEvents(q); } catch (QueryException ex) { LOG.warn("Failed to search group messages: {}", ex.getMessage()); } return result; }
queryManager.createQuery(query, Query.XWQL).bindValue("date", new Date(ts)).setLimit(number).setOffset( start).execute();
queryResult = queryManager.createQuery(query, Query.XWQL).bindValue("space", spaceName).bindValue("name", pageName) .setLimit(number).bindValue("language", "").setOffset(start).execute();
@Override public List<Event> getRecentDirectMessages(int limit, int offset) { List<Event> result = new ArrayList<Event>(); try { Query q = this.qm.createQuery( "where event.application = 'MessageStream' and event.type = 'directMessage'" + " and event.stream = :targetUser order by event.date desc", Query.XWQL); q.bindValue("targetUser", this.serializer.serialize(this.bridge.getCurrentUserReference())); q.setLimit(limit > 0 ? limit : 30).setOffset(offset >= 0 ? offset : 0); result = this.stream.searchEvents(q); } catch (QueryException ex) { LOG.warn("Failed to search direct messages: {}", ex.getMessage()); } return result; }
queryResult = queryManager.createQuery(query, Query.XWQL).bindValue("space", spaceName).bindValue("name", pageName) .setLimit(number).bindValue("language", language).setOffset(start).execute();
"select distinct doc.fullName from XWikiDocument as doc where doc.parent = :parent order by doc.fullName asc"; List<String> childPageFullNames = queryManager.createQuery(queryString, Query.XWQL).bindValue("parent", doc.getFullName()).setOffset(start) .setLimit(number).execute();
Query query = queryManager.createQuery(queryString, Query.XWQL).setLimit(number).setOffset(start); for (String param : filters.keySet()) { query.bindValue(param, String.format("%%%s%%", filters.get(param).toUpperCase()));
queryManager.getNamedQuery("getSpaces").setOffset(start).setLimit(number).execute();
query.setOffset(start); query.setLimit(nb);
queryManager.getNamedQuery("getSpaceDocsName").bindValue("space", spaceName).setOffset(start).setLimit( number).execute();
queryResult = queryManager.createQuery(query, Query.XWQL).bindValue("className", className).setLimit(number) .setOffset(start).execute();
queryManager.createQuery(query, Query.XWQL).bindValue("date", date).setLimit(numberOfResults).setOffset( start).execute();
query.setOffset(offset); query.setLimit(limit);
.createQuery( "/*/*[obj/XWiki/" + (user ? CLASS_SUFFIX_XWIKIUSERS : CLASS_SUFFIX_XWIKIGROUPS) + "]/@fullName", Query.XPATH).setLimit(nb).setOffset(start).execute(); } catch (QueryException ex) { throw new XWikiException(0, 0, ex.getMessage(), ex);