全文elasticsearch填充嵌套对象并按字段分数排序命中

Question

我有 2 个文档，ShopDocument 和 ProductDocument。我需要的是过滤掉所有字段 hidden 和 removed 等于 true 的商店，从留下的商店中过滤掉具有 < code>removed 和 hidden 字段等于 true，然后从剩下的内容中，我想过滤掉与某些字符串不匹配的商店和产品（匹配需要位于某些字段中）并根据分数对结果进行排序我将给每个字段（就像在lucene中）。这是我的文档：

@Document(indexName = Indices.SHOP_INDEX)
@Setting(settingPath = Constants.esSettingsPath)
@Data
public class ShopDocument {

@Id
@Field(type = FieldType.Keyword)
private Long id;

@Field(type = FieldType.Keyword)
private Long companyId;

@Field(type = FieldType.Boolean)
private Boolean companyHidden;

@Field(type = FieldType.Keyword)
private String slug;

@Field(type = FieldType.Keyword)
private String postalCode;

@Field(type = FieldType.Keyword)
private String addressLine;

@Field(type = FieldType.Boolean)
private boolean hidden;

@Field(type = FieldType.Boolean)
private boolean removed;

@Field(type = FieldType.Text)
private String name;

@Field(type = FieldType.Nested)
private List<ProductDocument> products = new ArrayList<>();

@Field(type = FieldType.Double)
private Double latitude;

@Field(type = FieldType.Double)
private Double longitude;

@Field(type = FieldType.Integer)
private Integer maxDeliveryDistance;
}



@Document(indexName = Indices.Product_INDEX)
@Setting(settingPath = Constants.esSettingsPath)
@Data
public class ProductDocument {

@Id
@Field(type = FieldType.Keyword)
private String id;

@Field(type = FieldType.Text)
private String name;

@Field(type = FieldType.Text)
private String description;

@Field(type = FieldType.Boolean)
private boolean hidden;

@Field(type = FieldType.Boolean)
private boolean removed;

@Field(type = FieldType.Long)
private Long oldPrice;

@Field(type = FieldType.Long)
private Long price;

我尝试了以下操作：

    BoolQueryBuilder builder = boolQuery();

    builder.must(termQuery("hidden", false))
            .must(termQuery("removed", false))
            .must(nestedQuery("products", termQuery("products.hidden", false), ScoreMode.None))
            .must(nestedQuery("products", termQuery("products.removed", false), ScoreMode.None));

            SearchHits<ShopDocument> searchHits = operations.search(qb.build(), ShopDocument.class, IndexCoordinates.of(Indices.SHOP_INDEX));

此查询应返回所有 hidden 和 removed 等于 false 的商店code> 以及商店中具有 hidden 和 removed 的所有产品等于 false，但它只会过滤掉商店并保留产品原样。提前致谢！

Answer 1

您必须调用NestedQueryBuilder 类的innerHits 方法。
此方法仅检索匹配的嵌套对象。
因此你的代码变成：

BoolQueryBuilder builder = boolQuery();
builder.must(termQuery("hidden", false))
       .must(termQuery("removed", false))
       .must(nestedQuery("products", termQuery("products.hidden", false), ScoreMode.None).innerHits(new InnerHitBuilder()));
       .must(nestedQuery("products", termQuery("products.removed", false), ScoreMode.None).innerHits(new InnerHitBuilder()));

SearchHits<ShopDocument> searchHits = operations.search(qb.build(), ShopDocument.class, IndexCoordinates.of(Indices.SHOP_INDEX));