如何在Spring boot中使用QueryBuilder列表中的NativeSearchQueryBuilder构建查询？

Question

如果某些属性匹配，我已经添加了一个QueryBuilders列表。现在，我想使用这些列表进行搜索。

    @Override
    public List<com.example.jobcandidatemanagement.documents.Job> searchJobs(String phrase, LocalDate startDate, LocalDate endDate, double offeredSalary, Availability availability) {

        List<QueryBuilder> searchQueries = new ArrayList<>();

        if (phrase != null) {
            QueryBuilder byPhrase = QueryBuilders.multiMatchQuery(phrase, "position", "description");
            searchQueries.add(byPhrase);
        }

        if (startDate != null && endDate != null) {
            QueryBuilder byStartDate = QueryBuilders.rangeQuery("startDate").gt(JsonData.of(startDate));
            QueryBuilder byEndDate = QueryBuilders.rangeQuery("endDate").lt(JsonData.of(endDate));
            searchQueries.add(byStartDate);
            searchQueries.add(byEndDate);
        }

        if (offeredSalary >= 0) {
            QueryBuilder byOfferedSalary = QueryBuilders.rangeQuery("offeredSalary").lte(offeredSalary);
            searchQueries.add(byOfferedSalary);
        }

        if (availability != null) {
            QueryBuilder byAvailability = QueryBuilders.matchQuery("availability", availability);
            searchQueries.add(byAvailability);
        }

    }

我想创建一个查询使用以上所有queryBuilder。大概是这样的:

Query query = new NativeSearchQueryBuilder().withQuery(byPhrase)
                                            .withQuery(byStartDate)
                                            .withQuery(byEndDate)
                                            .withQuery(byOfferedSalary)
                                            .withQuery(byAvailability)
                                            .build();

Answer 1

您可以重写方法，通过使用其< code > must(query builder query builder)方法，将每个新的< code>QueryBuilder添加到< code>List中，而不是添加到< code>BoolQueryBuilder中:

BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();

if (phrase != null) {
    QueryBuilder byPhrase = QueryBuilders.multiMatchQuery(phrase, "position", "description");
    boolQueryBuilder.must(byPhrase);
}
// adding other builders

BoolQueryBuilder还实现了QueryBuilder接口，因此您可以执行以下操作：

Query query = new NativeSearchQueryBuilder().withQuery(boolQueryBuilder).build();

请注意，must（） 方法意味着传递的查询必须出现在匹配的文档中，并且将有助于评分。如果您不想影响评分，请尝试 filter（QueryBuilder queryBuilder），它执行相同的操作，但传递的查询不会对评分产生影响。