How to make double nested query in C# Nest

Question

I've got problem with nested query.

My model looks like that:

public class Car
{
    public int Age {get; set;}  
    public List<User> Users {get; set;}

}

public class User
{
    public List<string> Names {get; set;}
    public List<string> Surnames {get; set;}

}

It can't be modify.

and my object looks like:

{
  "age": 12,
  "users": [
    {
      "names": [
        "Adam",
        "Bob"
      ],
      "surnames": [
        "xyz",
        "abc"
      ]
    }
  ]
}

How should look code to find car whose user is Bob? I know that example is not very good, but it shows central point of my problem.

It is not clear what exactly you want ? You need the list of the car whose user name is Bob? — Seckin Celik
– Seckin Celik, Commented Dec 19, 2017 at 17:31

MKasprzyk · Accepted Answer · 2017-12-21 13:53:06Z

1

var result1 = await _ec.SearchAsync<Car>(s => s.Query(q => q.Term(t => t.Field("users.names").Value("Bob"))));

answered Dec 21, 2017 at 13:53

MKasprzyk

4995 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to make double nested query in 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