Filter elastic data on array count

Question

How can we fetch candidates which have at least one phone number from the below index data along with other conditions like must and should?

Using elastic version 6.*

        {
            "_index": "test",
            "_type": "docs",
            "_id": "1271",
            "_score": 1.518617,
            "_source": {
                "record": {
                    "createdDate": "2020-10-16T10:49:51.53",
                    "phoneNumbers": [
                        {
                            "type": "Cell",
                            "id": 0,
                            "countryCode": "+1",
                            "phoneNumber": "7845200448",
                            "extension": "",
                            "typeId": 700
                        }
                    ]
                },
                "entityType": "Candidate",                   
                "dbId": "1271",
                "id": "1271"
            }
        }

phonenumbers is an array type,so need candidates which have atleast one phone number in that array. array.length > 0 — Ramakrishna Reddy
– Ramakrishna Reddy, Commented Oct 16, 2020 at 12:19

Bhavya · Accepted Answer · 2020-10-16 12:28:30Z

3

You can use terms query that returns documents that contain one or more exact terms in a provided field.

Search Query:

{
  "query": {
    "bool": {
      "must": [
        {
          "terms": {
            "record.phoneNumbers.phoneNumber.keyword": [
              "7845200448"
            ]
          }
        }
      ]
    }
  }
}

Search Result:

"hits": [
      {
        "_index": "stof_64388591",
        "_type": "_doc",
        "_id": "1",
        "_score": 1.0,
        "_source": {
          "record": {
            "createdDate": "2020-10-16T10:49:51.53",
            "phoneNumbers": [
              {
                "type": "Cell",
                "id": 0,
                "countryCode": "+1",
                "phoneNumber": "7845200448",
                "extension": "",
                "typeId": 700
              }
            ]
          },
          "entityType": "Candidate",
          "dbId": "1271",
          "id": "1271"
        }
      }
    ]

Update 1: For version 7.*

You need to use a script query, to filter documents based on the provided script.

{
  "query": {
    "bool": {
      "filter": {
        "script": {
          "script": {
            "source": "doc['record.phoneNumbers.phoneNumber.keyword'].length > 0",
            "lang": "painless"
          }
        }
      }
    }
  }
}

For version 6.*

{
  "query": {
    "bool": {
      "filter": {
        "script": {
          "script": {
            "source": "doc['record.phoneNumbers.phoneNumber.keyword'].values.length > 0",
            "lang": "painless"
          }
        }
      }
    }
  }
}

edited Oct 16, 2020 at 12:28

answered Oct 16, 2020 at 11:58

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

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

3 Comments

Bhavya Over a year ago

@Ramakrishna Reddy please go through my updated answer, and let me know if this resolves your issue ?

Bhavya Over a year ago

@Ramakrishna Reddy I tried the above script queries locally also, and they are working fine.

Ramakrishna Reddy Over a year ago

yeah it working my bad, thank u. you are saviour :)

Saeed Nasehi · Accepted Answer · 2020-10-16 13:41:18Z

1

You can use exists query for this purpose like below which is a lightweight query in comparison with scripts:

{
  "query": {
      "exists": {
        "field": "record.phoneNumbers.phoneNumber"
      }
  }
}

edited Oct 16, 2020 at 13:41

answered Oct 16, 2020 at 13:27

Saeed Nasehi

1,0001 gold badge14 silver badges29 bronze badges

3 Comments

Saeed Nasehi Over a year ago

let me check it again!

Ramakrishna Reddy Over a year ago

I just need check phonenumbers.count > 0

Saeed Nasehi Over a year ago

I edited my query. This query returns documents that have at least one phone number.

Collectives™ on Stack Overflow

Filter elastic data on array count

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related