ElasticsearchNEST-按多個欄位過濾

我有一個查詢，并希望通過多個欄位進行搜索，以防萬一沒有結果uuid需要通過以下方式執行相同操作parentUuid：

C# 查詢：

return new NestedQuery
{
    Path = Infer.Field<ElasticDocument>(t => t.KeywordFields),
    Query = new BoolQuery
    {
        Filter = new List<QueryContainer>
        {
            new TermsQuery
            {
                Field = Infer.Field<ElasticDocument>(t => t.KeywordFields),
                Terms = new List<string>
                {
                    "term2"
                },
                Boost = 10
            }
        },
        Should = new List<QueryContainer>
        {
            new TermQuery
            {
                Field = Infer.Field<ElasticDocument>(t => t.KeywordFields.First().UUID),
                Value = filter.UUID
            },
            new TermQuery
            {
                Field = Infer.Field<ElasticDocument>(t => t.KeywordFields.First().ParentUUID),
                Value = filter.UUID
            },
        }
    }
};

檔案示例：

"keywordFields": [
    {
        "value": "term1",
        "uuid": "bf18ee9f-7592-488d-7985-2b9fe8b878ca",
        "parentUUID": null
    },
    {
        "value": "term2",
        "uuid": "079205ed-30df-08f6-02a1-9caf093c3be0",
        "parentUUID": "103d6061-cb99-4fba-8118-2ea501e4425d"
    }
]

如果'UUID'沒有結果，如何更新查詢以使用或條件，那么讓我們通過ParentUUID？

uj5u.com熱心網友回復：

嘗試結合布爾查詢：

 nested1 = new NestedQuery {
                Path = Infer.Field<ElasticDocument>(t => t.KeywordFields),
                Query = new BoolQuery {
                    Filter = new List<QueryContainer>
                    {
                        new TermsQuery {
                            Field = Infer.Field<ElasticDocument>(t => t.KeywordFields),
                            Terms = new List<string>
                            {
                                "term2"
                            },
                            Boost = 10
                        }
                    }
                }
            };
        
       nested2 = new NestedQuery {
            Path = Infer.Field<ElasticDocument>(t => t.KeywordFields),
            Query = new BoolQuery {
                Filter = new List<QueryContainer>
                {
                    new TermsQuery {
                        Field = Infer.Field<ElasticDocument>(t => t.KeywordFields),
                        Terms = new List<string>
                        {
                            "term2"
                        },
                        Boost = 10
                    }
                },
                Should = new List<QueryContainer>
                {
                    new BoolQuery {
                        MustNot = new List<QueryContainer> {
                            new TermQuery
                            {
                                Field = Infer.Field<ElasticDocument>(t => t.KeywordFields.First().UUID),
                                Value = filter.UUID
                            }
                        },
                        Must = new List<QueryContainer> {
                            new TermQuery
                            {
                                Field = Infer.Field<ElasticDocument>(t => t.KeywordFields.First().parentUUID),
                                Value = filter.UUID
                            }
                        }
                    }
                }
            }
        };

并且應該嵌套1 和嵌套2

注意：不是此編輯的 IDE，nested2 查詢肯定可以簡化。

標籤：弹性搜索 .net-core 巢

上一篇：如何使用PytonFlask連接到Elasticsearch

下一篇：自動撰寫復雜的彈性請求