unire query separate in una query
Nov 30 2020
Ho la seguente query utilizzando boolQueryBuilder che controlla se status1 o status2 E il tempo è inferiore a currentTime corrisponde a:
public BoolQueryBuilder createSearchQuery(Long currentTime) {
// Build and operator
final BoolQueryBuilder firstAndOperator = createAndOperator(currentTime, "status1");
// Build AND operator
final BoolQueryBuilder secondAndOperator = createAndOperator(currentTime, "status2);
// Build OR
return createOrOperator(firstAndOperator, secondAndOperator);
}
private BoolQueryBuilder createOrOperator(BoolQueryBuilder firstAndOperator, BoolQueryBuilder secondAndOperator) {
return new BoolQueryBuilder()
.should(firstAndOperator)
.should(secondAndOperator);
}
private BoolQueryBuilder createAndOperator(Long currentDate, Status status) {
return QueryBuilders.boolQuery()
.must(QueryBuilders.matchQuery(STATUS, status))
.must(QueryBuilders.rangeQuery(TIME).lte(currentDate));
}
come unirli usando multiMatchQuery?
questo è il mio tentativo ma non funziona
public BoolQueryBuilder createSearchQuery(Long currentTime) {
return new BoolQueryBuilder()
.should(QueryBuilders
.multiMatchQuery("status1" + " " + "status2", STATUS)
.type(MultiMatchQueryBuilder.Type.PHRASE_PREFIX)
.operator(Operator.OR))
.must(QueryBuilders.rangeQuery(TIME)
.lte(currentTime));
}
Risposte
Val Nov 30 2020 at 16:53
Penso che la tua multi_matchquery sia sbagliata e dovresti usare anche al filterposto di must. Quindi dovrebbe essere così invece:
public BoolQueryBuilder createSearchQuery(Long currentTime) {
return new BoolQueryBuilder()
.should(QueryBuilders
.multiMatchQuery(STATUS, "status1", "status2")
.operator(Operator.OR))
.filter(QueryBuilders.rangeQuery(TIME)
.lte(currentTime));
Ma non lo userei multi_matchper quello scopo, ma sfrutterei due termfiltri:
public BoolQueryBuilder createSearchQuery(Long currentTime) {
return new BoolQueryBuilder()
.minimumShouldMatch(1)
.should(QueryBuilders.matchQuery("status1", STATUS))
.should(QueryBuilders.matchQuery("status2", STATUS))
.filter(QueryBuilders.rangeQuery(TIME)
.lte(currentTime));