elasticsearch -check if array contains a value

Question

I want to check on an field of an array long type that includes some values. the only way I found is using script: ElasticSearch Scripting: check if array contains a value

but it still not working fore me: Query:

  {
    "query": {
        "filtered": {
            "query": {
                "match_all": {}
            },
            "filter": {
                "script": {
                    "script": "doc['Commodity'].values.contains(param1)",
                    "params": {
                        "param1": 50
                    }
                }
            }
        }
    }
}

but I get 0 hits. while I have the records:

{
"_index" : "aaa",
"_type" : "logs",
"_id" : "2zzlXEOgRtujWiCGtX6s9Q",
"_score" : 1,
"_source" : {

   "Commodity" : [
     50
    ],
   "Type" : 1,
    "SourceId" : "fsd",
      "Id" : 123
  }
}

Why don't you use { "query": { "match": { "Commodity": 50 } } }? — Andrei Stefan
– Andrei Stefan, Commented Jun 10, 2015 at 11:29
I have a long list of filters like that. + I want to be able to filter with more than one value, example: Commodity to contain 50 and 45 — griffon vulture
– griffon vulture, Commented Jun 10, 2015 at 11:32

Andrei Stefan · Accepted Answer · 2015-06-10 11:37:51Z

6

Try this instead of that script:

{
  "query": {
    "filtered": {
      "filter": {
        "terms": {
          "Commodity": [
            55,
            150
          ],
          "execution": "and"
        }
      }
    }
  }
}

answered Jun 10, 2015 at 11:37

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

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

Comments

ShashankAC · Accepted Answer · 2019-06-25 12:52:09Z

6

For those of you using the latest version of Elasticsearch (7.1.1), please note that "filtered" and "execution" are deprecated so @Andrei Stefan's answer may not help anymore.

You can go through the below discussion for alternative approaches.

https://discuss.elastic.co/t/is-there-an-alternative-solution-to-terms-execution-and-on-es-2-x/41089

In the answer written by nik9000 in the above discussion, I just replaced "term" with "terms" (in PHP) and it started working with array inputs and AND was applied with respect to each of the "terms" keys that I used.

EDIT: Upon request I will post a sample query written in PHP.

'body' => [ 
      'query' => [ 
           'bool' => [
               'filter' => [
                     ['terms' => ['key1' => array1]],
                     ['terms' => ['key2' => array2]],   
                     ['terms' => ['key3' => array3]],
                     ['terms' => ['key4' => array4]],                            
                           ]
                     ]
                 ]
             ]

key1,key2 and key3 are keys present in my elasticsearch data and they will be searched for in their respective arrays. AND function is applied between the ["terms" => ['key' => array ] lines.

edited Jun 25, 2019 at 12:52

answered Jun 25, 2019 at 11:28

ShashankAC

1,07813 silver badges28 bronze badges

1 Comment

Akber Iqbal Over a year ago

can you share the alternate approaches here (instead of just a link)?... that'll make the answer clearer and less dependent on external sources

dotnetdev_2009 · Accepted Answer · 2019-09-16 20:11:31Z

1

For those of you who are using es 6.x, this might help. Here I am checking whether the user([email protected]) has any orders by passing in an array of orders

GET user-orders/_search
{
  "query": {
    "bool": {
      "filter": [
         {
           "terms":{
             "orders":["123456","45678910"]
           }
         },
         {
           "term":{
             "user":"[email protected]"
           }
         }
        ]
    }
  }
}

answered Sep 16, 2019 at 20:11

dotnetdev_2009

7831 gold badge15 silver badges36 bronze badges

1 Comment

dotnetdev_2009 Over a year ago

Yo can check the hits.total to see it returned any results. Will be > 0 if it has any results

Collectives™ on Stack Overflow

elasticsearch -check if array contains a value

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related