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")) {
@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"); }
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); } else {
@Override public Iterator<EsInstance> getInstanceCreatedBetween(Date start, Date end) throws Exception { Preconditions.checkArgument(start.getTime() < end.getTime()); QueryBuilder queryBuilder = QueryBuilders.boolQuery().must( QueryBuilders.rangeQuery("created_time").from(start).to(end).includeLower(true) .includeUpper(false) ); ScrollableResponse<List<EsInstance>> response = this.retrieveScrollByQuery(queryBuilder, EsMapper.getIncludeFields(getInstanceClass()), BATCHSIZE, str -> (EsInstance) insertMapper.readValue(str, getInstanceClass())); EsIterator<EsInstance> iterator = new EsIterator<>(response, r -> scrollNext(r.getContinousToken(), str -> (EsInstance) insertMapper.readValue(str, getInstanceClass()))); return iterator; }
queryBuilder.to(to); list.add(queryBuilder.includeLower(includeLower).includeUpper(includeUpper)); return this;
.to(endTime) .includeLower(true) .includeUpper(true));
.to(endTime) .includeLower(true) .includeUpper(true));
rangeQuery.to(to); rangeQuery.includeLower(includeLower); rangeQuery.includeUpper(includeUpper); if (timeZone != null) { rangeQuery.timeZone(timeZone);
public Search queryGetEventQueryDefinition(EventQueryDefinition query, String action) { BoolQueryBuilder booleanQuery = new BoolQueryBuilder(); // Optional constant for action filter if (action != null) { query.getActionFilters().add(action); } QueryBuilder typeQuery = QueryBuilders.termQuery("type", EventConstants.TARGET_FEATURE); // Timestamp filter RangeQueryBuilder timestampFilter = QueryBuilders.rangeQuery("timestamp") // .gt(query.getFrom().longValue()) // .lt(query.getTo().longValue()) // .includeLower(false) // .includeUpper(false); booleanQuery.must(typeQuery); booleanQuery.must(timestampFilter); // Optional filters addOptionalFilters(booleanQuery, query.getActionFilters(), "action"); addOptionalFilters(booleanQuery, query.getHostFilters(), "hostName"); addOptionalFilters(booleanQuery, query.getNamesFilter(), "name"); addOptionalFilters(booleanQuery, query.getSourceFilters(), "source"); // Warning : default size is set to 10 results, that's why it's // overridden SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder().size(100); Search searchQuery = new Search.Builder(searchSourceBuilder.query(booleanQuery.toString()).toString()) // .addIndex(connection.getIndexName()) // .addType(ElasticConstants.TYPE_EVENT) // .build(); return searchQuery; }
.includeUpper(true); dateFilter.from(from.toEpochMilli()); dateFilter.to(to.toEpochMilli());
rangeQuery.to(to); rangeQuery.includeLower(includeLower); rangeQuery.includeUpper(includeUpper); if (timeZone != null) { rangeQuery.timeZone(timeZone);
rangeQuery.to(to); rangeQuery.includeLower(includeLower); rangeQuery.includeUpper(includeUpper); if (timeZone != null) { rangeQuery.timeZone(timeZone);
rangeQuery.to(to); rangeQuery.includeLower(includeLower); rangeQuery.includeUpper(includeUpper); if (timeZone != null) { rangeQuery.timeZone(timeZone);