# Multiple field search is not working in field having array of object in Elasticsearch 6

**URL:** <https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036>\
**Category:** Elasticsearch\
**Created:** [March 29, 2018, 6:50am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036 "2018-03-29T06:50:34Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tarun\_Jangra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tarun_jangra/32/1426_2.png) [@Tarun\_Jangra](https://discuss.elastic.co/u/Tarun_Jangra)\
**Post date:** [March 29, 2018, 6:50am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/1 "2018-03-29T06:50:34Z")

</div>

Here is the type of document i have:

```
{
"id": 41,
"invoice_number": "INV-0022",
"order_number": null,
"status": "Draft",
"object_id": "invoice_41",
"viewed_date": null,
"total_amount": 21640,
"total_amount_formatted": "₹ 21,640.00",
"invoice_date_formatted": "16/08/23",
"customer_viewed": null,
"viewed_date_formatted": false,
"balance_due": 21640,
"balance_due_formatted": "₹ 21,640.00",
"due_date_formatted": "16/08/23",
"customer_id": 3,
"updated_at": "2016-08-24 19:41:59",
"created_at": "2016-08-23 16:39:57",
"recurring_id": null,
"party": {
"display_name": "MANI RAM BALWANT RAI",
"contacts": [
{
"name": "BALWANT",
"email": "EFF@GMAIL.COM",
"mobile": "9988000000",
"phone": "2533433"
}
]
},
"status_formatted": "Draft",
"tags": [
"invoice"
,
"organization_id_11"
,
"Draft"
]
},
"sort": [
1471970397000
]
}

```

Here is my query:

```
{
  "query": {
    "multi_match": {
      "query": "ram",
      "fields": [
        "invoice_number",
        "status",
        "party.display_name",
        "party.contacts"
      ]
    }
  },
  "sort": {
    "created_at": "desc"
  }
}

```

When i have query "ram" it results perfectly fine. But when my query is "EFF@GMAIL.COM", it is not resulting any hits. Here i'm expecting this to be searched in array of party.contacts. I don't know how to refer all elements of **party.contacts** field.

Any reference will be helpful.  
Thanks

---

<div class="post-metadata">

**Author:** ![abdon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abdon/32/9195_2.png) [@abdon](https://discuss.elastic.co/u/abdon)\
**Post date:** [March 29, 2018, 7:31am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/2 "2018-03-29T07:31:16Z")

</div>

You can use wildcards to query multiple child fields, like this: `party.contacts.*`.

The full query would look like this:

```auto
{
  "query": {
    "multi_match": {
      "query": "ram",
      "fields": [
        "invoice_number",
        "status",
        "party.display_name",
        "party.contacts.*"
      ]
    }
  },
  "sort": {
    "created_at": "desc"
  }
}

```

---

<div class="post-metadata">

**Author:** ![Tarun\_Jangra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tarun_jangra/32/1426_2.png) [@Tarun\_Jangra](https://discuss.elastic.co/u/Tarun_Jangra)\
**Post date:** [March 29, 2018, 7:45am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/3 "2018-03-29T07:45:26Z")

</div>

Hi,

Thanks for your reply.

In this case, keeping following query should also work. BTW Is there any performance concern i should be aware about?

```
   {
  "query": {
    "multi_match": {
      "query": "ram",
      "fields": [
        "invoice_number",
        "status",
        "party.*"
      ]
    }
  },
  "sort": {
    "created_at": "desc"
  }
}
```

---

<div class="post-metadata">

**Author:** ![abdon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abdon/32/9195_2.png) [@abdon](https://discuss.elastic.co/u/abdon)\
**Post date:** [March 29, 2018, 7:48am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/4 "2018-03-29T07:48:17Z")

</div>

Generally, the more fields you query, the more expensive the query generally is going to be. Looking at your sample document it does not seem like you will be querying an excessive amount of fields though.

---

<div class="post-metadata">

**Author:** ![Tarun\_Jangra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tarun_jangra/32/1426_2.png) [@Tarun\_Jangra](https://discuss.elastic.co/u/Tarun_Jangra)\
**Post date:** [March 29, 2018, 7:48am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/5 "2018-03-29T07:48:19Z")

</div>

BTW, i tried with wild character but it did not work.

---

<div class="post-metadata">

**Author:** ![Tarun\_Jangra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tarun_jangra/32/1426_2.png) [@Tarun\_Jangra](https://discuss.elastic.co/u/Tarun_Jangra)\
**Post date:** [March 29, 2018, 9:46am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/6 "2018-03-29T09:46:08Z")

</div>

Actually it is working when i give exact case to be searched. my search query is [EFF@GMAIL.COM](mailto:EFF@GMAIL.COM). So i have to keep the exact case. Otherwise it is working fine on rest of the fields.

thank.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 26, 2018, 9:46am UTC](https://discuss.elastic.co/t/multiple-field-search-is-not-working-in-field-having-array-of-object-in-elasticsearch-6/126036/7 "2018-04-26T09:46:26Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.