select matching objects from array in elasticsearch

Question

{
    class: 1,
    users: [{
        name: 'abc',
        surname: 'def'
    }, {
        name: 'xyz',
        surname: 'wef'
    }, {
        name: 'abc',
        surname: 'pqr'
    }]
}

I have a document structure like above object and I want to return only users who have name 'abc' but problem is it matches name 'abc' but returns all array. I want only matched users .

Mapping -

{
        "class":"string",
        "users" : {
            "type" : "nested",
            "properties": {
                "name" : {"type": "string" },
                "surname"  : {"type": "string" }
            }
        }
    }

Can you show your query? and possibly also your mapping?

Val
– Val

2015-07-30 09:35:39 +00:00
Commented Jul 30, 2015 at 9:35 — Val
– Val, Commented Jul 30, 2015 at 9:35

Val · Accepted Answer · 2015-07-30 10:15:08Z

17

Then if you have your users field mapped as nested type, it's a good start!

Using nested inner_hits, you can retrieve only the matching user names with a query like this one:

{
  "_source": false,
  "query": {
    "nested": {
      "path": "users",
      "inner_hits": {        <---- this is where the magic happens
        "_source": [
          "name"
        ]
      },
      "query": {
        "bool": {
          "must": [
            {
              "term": {
                "users.name": "abc"
              }
            }
          ]
        }
      }
    }
  }
}

answered Jul 30, 2015 at 10:15

Val

218k14 gold badges377 silver badges384 bronze badges

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

9 Comments

Prasad Bhosale Over a year ago

can we do "_source": false for specific _type ?

Val Over a year ago

You can definitely narrow your search query to a specify type by specifying the type directly in the URL /my_index/my_type/_search if that's what you mean.

Jay Shah Over a year ago

Can we get all normal fields with only matching nested fields ? like { class: 1, users: [{ name: 'abc', surname: 'def' }] }

Val Over a year ago

@JayShah If you set _source: true it should get you what you want

Jay Shah Over a year ago

Yes, but if I set _source: true, It gives me all nested objects. I need only matching nested objects. like { class: 1, users: [{ name: 'abc', surname: 'def' }] } Is that possible ?

|

Collectives™ on Stack Overflow

select matching objects from array in elasticsearch

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related