public long count(final String index, final String histogram_timefield, final long millis) { try { SearchResponse response = elasticsearchClient.prepareSearch(index) .setSize(0) .setQuery(millis <= 0 ? QueryBuilders.constantScoreQuery(QueryBuilders.matchAllQuery()) : QueryBuilders.rangeQuery(histogram_timefield).from(new Date(System.currentTimeMillis() - millis))) .execute() .actionGet(); return response.getHits().getTotalHits(); } catch (Throwable e) { DAO.severe(e); return 0; } }
private static void addCreatedAfterByProjectsFilter(Map<String, QueryBuilder> filters, IssueQuery query) { Map<String, PeriodStart> createdAfterByProjectUuids = query.createdAfterByProjectUuids(); BoolQueryBuilder boolQueryBuilder = boolQuery(); createdAfterByProjectUuids.forEach((projectUuid, createdAfterDate) -> boolQueryBuilder.should(boolQuery() .filter(termQuery(FIELD_ISSUE_PROJECT_UUID, projectUuid)) .filter(rangeQuery(FIELD_ISSUE_FUNC_CREATED_AT).from(BaseDoc.dateToEpochSeconds(createdAfterDate.date()), createdAfterDate.inclusive())))); filters.put("createdAfterByProjectUuids", boolQueryBuilder); }
private void addDatesFilter(Map<String, QueryBuilder> filters, IssueQuery query) { PeriodStart createdAfter = query.createdAfter(); Date createdBefore = query.createdBefore(); validateCreationDateBounds(createdBefore, createdAfter != null ? createdAfter.date() : null); if (createdAfter != null) { filters.put("__createdAfter", QueryBuilders .rangeQuery(FIELD_ISSUE_FUNC_CREATED_AT) .from(BaseDoc.dateToEpochSeconds(createdAfter.date()), createdAfter.inclusive())); } if (createdBefore != null) { filters.put("__createdBefore", QueryBuilders .rangeQuery(FIELD_ISSUE_FUNC_CREATED_AT) .lt(BaseDoc.dateToEpochSeconds(createdBefore))); } Date createdAt = query.createdAt(); if (createdAt != null) { filters.put("__createdAt", termQuery(FIELD_ISSUE_FUNC_CREATED_AT, BaseDoc.dateToEpochSeconds(createdAt))); } }
if (constraints_positive.remove("len25")) { nops.add(QueryBuilders.constantScoreQuery(QueryBuilders .rangeQuery(Constraint.len25.field_name).from(26).to(1000).includeLower(true).includeUpper(false))); }; if (constraints_positive.remove("len50")) { nops.add(QueryBuilders.constantScoreQuery(QueryBuilders .rangeQuery(Constraint.len50.field_name).from(51).to(1000).includeLower(true).includeUpper(false))); }; if (constraints_positive.remove("len75")) { nops.add(QueryBuilders.constantScoreQuery(QueryBuilders .rangeQuery(Constraint.len75.field_name).from(76).to(1000).includeLower(true).includeUpper(false))); }; if (constraints_positive.remove("len100")) { nops.add(QueryBuilders.constantScoreQuery(QueryBuilders .rangeQuery(Constraint.len100.field_name).from(101).to(1000).includeLower(true).includeUpper(false))); }; if (modifier.containsKey("from")) { Calendar since = DateParser.parse(modifier.get("since").iterator().next(), timezoneOffset); this.since = since.getTime(); RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery(AbstractObjectEntry.CREATED_AT_FIELDNAME).from(this.since); if (modifier.containsKey("until")) { Calendar until = DateParser.parse(modifier.get("until").iterator().next(), timezoneOffset);
/** * The from part of the range query. Null indicates unbounded. */ public RangeQueryBuilder gt(Object from) { return from(from, false); }
/** * The from part of the range query. Null indicates unbounded. */ public RangeQueryBuilder gte(Object from) { return from(from, true); }
/** * The from part of the range query. Null indicates unbounded. */ public RangeQueryBuilder from(Object from) { return from(from, this.includeLower); }
@Override public QueryBuilder getFilterBuilder() { if (op.getOperator().equals(Operators.EQUALS.value())) { return QueryBuilders.queryStringQuery(name.getName() + ":" + value.getValue().toString()); } else if (op.getOperator().equals(Operators.BETWEEN.value())) { return QueryBuilders.rangeQuery(name.getName()).from(range.getLow()).to(range.getHigh()); } else if (op.getOperator().equals(Operators.IN.value())) { return QueryBuilders.termsQuery(name.getName(), valueList.getList()); } else if (op.getOperator().equals(Operators.NOT_EQUALS.value())) { return QueryBuilders.queryStringQuery("NOT " + name.getName() + ":" + value.getValue().toString()); } else if (op.getOperator().equals(Operators.GREATER_THAN.value())) { return QueryBuilders.rangeQuery(name.getName()).from(value.getValue()).includeLower(false).includeUpper(false); } else if (op.getOperator().equals(Operators.IS.value())) { if (value.getSysConstant().equals(ConstValue.SystemConsts.NULL)) { return QueryBuilders.boolQuery().mustNot(QueryBuilders.boolQuery().must(QueryBuilders.matchAllQuery()).mustNot(QueryBuilders.existsQuery(name.getName()))); } else if (value.getSysConstant().equals(ConstValue.SystemConsts.NOT_NULL)) { return QueryBuilders.boolQuery().mustNot(QueryBuilders.boolQuery().must(QueryBuilders.matchAllQuery()).must(QueryBuilders.existsQuery(name.getName()))); } } else if (op.getOperator().equals(Operators.LESS_THAN.value())) { return QueryBuilders.rangeQuery(name.getName()).to(value.getValue()).includeLower(false).includeUpper(false); } throw new IllegalStateException("Incorrect/unsupported operators"); }
if (q.length() > 0) query.filter(suggest); RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery(range_field); if (since != null) rangeQuery.from(since).includeLower(true); if (until != null) rangeQuery.to(until).includeUpper(true); query.filter(rangeQuery);
public long count(final String index, final String histogram_timefield, final long millis) { try { SearchResponse response = elasticsearchClient.prepareSearch(index) .setSize(0) .setQuery(millis <= 0 ? QueryBuilders.constantScoreQuery(QueryBuilders.matchAllQuery()) : QueryBuilders.rangeQuery(histogram_timefield).from(new Date(System.currentTimeMillis() - millis))) .execute() .actionGet(); return response.getHits().getTotalHits(); } catch (Throwable e) { Data.logger.warn("", e); return 0; } }
if ((from() != null && from().toString().contains("now")) || (to() != null && to().toString().contains("now"))) { return new MatchAllQueryBuilder(); if (from != null || to != null || format != null || timeZone != null) { RangeQueryBuilder newRangeQuery = new RangeQueryBuilder(fieldName); newRangeQuery.from(null); newRangeQuery.to(null); newRangeQuery.format = null;
Calendar since = DateParser.parse(modifier.get("since").iterator().next(), timezoneOffset); this.since = since.getTime(); RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery(WebMapping.last_modified.getMapping().name()).from(DateParser.formatGSAFS(this.since)); if (modifier.containsKey("until")) { Calendar until = DateParser.parse(modifier.get("until").iterator().next(), timezoneOffset);
/** * The from part of the range query. Null indicates unbounded. */ public RangeQueryBuilder gte(Object from) { return from(from, true); }
/** * The from part of the range query. Null indicates unbounded. */ public RangeQueryBuilder gte(Object from) { return from(from, true); }
/** * The from part of the range query. Null indicates unbounded. */ public RangeQueryBuilder from(Object from) { return from(from, this.includeLower); }
RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery(esQuery.getField()); if (esQuery.getFrom() != null) { rangeQuery.from(esQuery.getFrom());
RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery(esQuery.getField()); if (esQuery.getFrom() != null) { rangeQuery.from(esQuery.getFrom());
RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery(esQuery.getField()); if (esQuery.getFrom() != null) { rangeQuery.from(esQuery.getFrom());
private static void addCreatedAfterByProjectsFilter(Map<String, QueryBuilder> filters, IssueQuery query) { Map<String, PeriodStart> createdAfterByProjectUuids = query.createdAfterByProjectUuids(); BoolQueryBuilder boolQueryBuilder = boolQuery(); createdAfterByProjectUuids.forEach((projectUuid, createdAfterDate) -> boolQueryBuilder.should(boolQuery() .filter(termQuery(IssueIndexDefinition.FIELD_ISSUE_PROJECT_UUID, projectUuid)) .filter(rangeQuery(IssueIndexDefinition.FIELD_ISSUE_FUNC_CREATED_AT).from(BaseDoc.dateToEpochSeconds(createdAfterDate.date()), createdAfterDate.inclusive())))); filters.put("createdAfterByProjectUuids", boolQueryBuilder); }
rangeQuery.from(from); rangeQuery.to(to); rangeQuery.includeLower(includeLower);