Spring Data Elasticsearch Repository: Query for Nested Object

Question

I am using Spring Data Elasticsearch with a repository class. Here is My Object that I want to query through:

public class Person{
    String firstName;
    String lastName;
    Location location;
}

public class Location{
    String name;
}

@Query("{\"bool\" : {"
            + "\"should\" : [ "
                + "{"
                    + "\"term\" : {"
                        + "\"firstName\" : \"?0\""
                    + "}"
                + "},"
                + "{"
                    + "\"term\" : {"
                        + "\"lastName\" : \"?0\""
                    + "}"
                + "},"
                + "{"
                    + "\"term\" : {"
                        + "\"location.name\" : \"?0\""
                    + "}"
                + "}"
            + "]"
     + "}}")
List<Person> findByFirstNameOrLastName(String term);

I can not search in location.name - how can I change the Query that this will work?

UPDATE Mapping

{
    "properties" : {
        "firstName": {
            "type": "string",
            "analyzer": "firstNameNGram"
        },
        "lastName": {
            "type": "string",
            "analyzer": "firstNameNGram"
        },
        "location": {
            "type": "nested",
            "properties": {
                "name": {
                    "type": "string",
                    "analyzer": "firstNameNGram"
                },
                "company": {
                    "type": "nested",
                    "properties": {
                        "name": {
                            "type": "string",
                            "analyzer": "firstNameNGram"
                        }
                    }
                }
            }
        }
    }
}

Lukáš Sirhal · Accepted Answer · 2016-12-22 09:51:39Z

2

How looks your mapping if location object is nested you must use nested query :

nested query

query looks like:

"nested" : {
  "query" : {
    "bool" : {
      "should" : [
        {
          "term" : {
            "location.name" : {
              "value" : "?0"
            }
          }
        }
      ]
    }
  },
  "path" : "location"
}

edited Dec 22, 2016 at 9:51

answered Dec 22, 2016 at 9:43

Lukáš Sirhal

966 bronze badges

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

1 Comment

Timo Ademeit Over a year ago

Updated my Questionsection with added Mapping

Collectives™ on Stack Overflow

Spring Data Elasticsearch Repository: Query for Nested Object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related