Perform a query over a nested collection in ElasticSearch with NEST in .NET Core

Question

I am trying to perform a search over an index for the following object:

public class IndexedElement
{

    public Guid Id { get; set; }
    public long RowId { get; set; }
    public IndexedElementType Type { get; set; }
    public string Summary { get; set; }
    public string Description { get; set; }

    public IList<string> Tags { get; set; }

}

The purpose is to search by the Summary property, or by matching any of the strings inside the Tags collections

What I currently have is this:

    public IEnumerable<IndexedElement> Search(string description)
    {
        var query = GetClient().Search<IndexedElement>(s => s.From(0).Size(5)
            .Query(
                q => q.Term(p => p.Summary, description)
                ||
                q.Nested(n => n.Path(p => p.Tags).Query(q2 => q2.Terms(t => t.Field(f => f.Tags).Terms(description))))                    
            ));

        return query.Documents.ToList();
    }

But the Nested part is not working, I don't know if I am using it in the proper way or maybe I have to find another solution for that.

Any ideas?

Thank you all in advance

Russ Cam · Accepted Answer · 2019-02-27 09:58:45Z

1

You don't need to perform a nested query to query the Tags field, as each tag is only a primitive JSON value i.e. a string. Just the terms query will suffice.

Where a nested query would be needed is where Tags is a POCO with multiple properties and is mapped as a nested datatype.

edited Feb 27, 2019 at 9:58

answered Feb 27, 2019 at 0:56

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

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

Collectives™ on Stack Overflow

Perform a query over a nested collection in ElasticSearch with NEST in .NET Core

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