Querying ElasticSearch with C# Nest

Question

Have an ElasticSearch index where the potential hits are build like this:

id: number,
source: string,
type: string,
organization: {
    main: [string],
    support: [string]
},
title: {
    main: [string],
    sub: [string]
}

My problem is that I can't search the elements in [].

No problem doing this:

var searchResults = client.Search<Document>(s => s
                .Index(****)
                .Type(****)
                .MatchAll()
                .Query(q =>
                    q.Term(p => p.source, "some source name")
                ))

But this one doesn't work:

var searchResults = client.Search<Document>(s => s
                .Index(****)
                .Type(****)
                .MatchAll()
                .Query(q =>
                    q.Term(p => p.organization.main[0], "some organization name")
                ))

I have also tried this version, but it also doesn't work:

var searchResults = client.Search<Document>(s => s
                .Index(****)
                .Type(****)
                .MatchAll()
                .Query(q =>
                    q.Term(p => p.organization.main, "some organization name")
                ))

Can anyone spot what is going wrong?

May you share index mapping?

Rob
– Rob

2016-10-28 14:02:11 +00:00
Commented Oct 28, 2016 at 14:02 — Rob
– Rob, Commented Oct 28, 2016 at 14:02

Russ Cam · Accepted Answer · 2016-10-29 22:35:07Z

2

You can use LINQ's .First() extension method to reference the "organization.main" field in Elasticsearch

var searchResults = client.Search<Document>(s => s
    .Index(****)
    .Type(****)
    .MatchAll()
    .Query(q =>
        q.Term(p => p.organization.main.First(), "some organization name")
    )
 );

Bear in mind that your query is operating over the whole array here, not the first item in organization.main as the usage of .First() might imply. Arrays are indexed as multi value fields which are unordered. They come back ordered in the _source however.

answered Oct 29, 2016 at 22:35

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying ElasticSearch with C# Nest

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related