Elasticsearch Search in nested array

Question

Hi i'm elasticsearch newbie and i have troubles with a query. I have data's as

{
    "user_id": "1",
    "date": "141462121",
    "name": "John",
    "surname": "Doe"
    "activity": [
      {
        "type": [
          "Outdoor",
          "Extreme"
        ],
        "name": "Example",
        "price": {
          "value": 50,
          "currency": "USD"
        }
      }
    ]
    "searchs": ""
  }
},
{
    "user_id": "2",
    "date": "141462121",
    "name": "Jane",
    "surname": "Doe"
    "activity": [
      {
        "type": [
          "Indoor"
        ],
        "name": "Example2",
        "price": {
          "value": 100,
          "currency": "USD"
        }
      },
      {
        "type": [
          "Outdoor"
        ],
        "name": "Example3",
        "price": {
          "value": 25,
          "currency": "USD"
        }
      }
    ]
    "searchs": ""
  }
}

and i want to search these datas by activity type. i tried nested queries like

"query": {
  "nested": {
     "path": "activity",
     "query": {
         "bool": {
             "must": [
                {"match": {
                   "activity.type": "outdoor"
                }}
           ]
       }
   }
}

and like

"query": {
  "nested": {
    "path": "activity",
    "query": {
      "nested": {
        "path": "type",
        "query": {
           "bool": {
               "must": [
                  {"match": {
                     "type.value": "outdoor"
                  }}
               ]
           }
        }
      }
    }
  }
}

but i couldn't succeed.

How can i search these datas by activity type?

jmluy · Accepted Answer · 2014-11-20 12:25:01Z

1

You can use a simple match query if you're just looking for records with an activity type like

{
  "query": {
    "match": {
      "activity.type": "Outdoor"
    }
  }
}

answered Nov 20, 2014 at 12:25

jmluy

1271 silver badge11 bronze badges

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

5 Comments

htkaya Over a year ago

When i use this. i can get only first acitivity's type records which has multiple activity for example when i run this query i can't get "Jane Doe" record.

jmluy Over a year ago

Are you sure there are 2 records on your index? And that when you are querying, you're not specifying a page size of 1? You can try using a plugin like head to browse your index.

htkaya Over a year ago

yes i'm sure i have larg amount of data but i sampled 15 example for trying. when i run query it doesn't gets users with multiple activities.

jmluy Over a year ago

Can you display the output you get when running the query above?

htkaya Over a year ago

Oh i found the error. it doesn't found because of charset error on my console. Thank you.

Collectives™ on Stack Overflow

Elasticsearch Search in nested array

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related