ElasticSearch and searching on multiple fields in PHP

Question

I am using the latest version of elasticsearch-php as well as the latest version of MongoDB and ElasticSearch.

I need to do a search on multiple fields that can contain one or multiple values. Example:

country_code should be either NL, BE or DE AND category should contain be AA01, BB01, CC02 or ZZ11

I thought I would solve it as followed (PHP):

$countries = array(“NL”, “BE”, “DE”);
$category = array(“AA01”, “BB01”, “CC02”, “ZZ11”);

$searchParams['body']['query']['bool']['must']['terms']['country'] = $countries;
$searchParams['body']['query']['bool']['must']['terms']['categories'] = $category;
$searchParams['body']['query']['bool']['must']['terms']['minimum_should_match'] = 1;

But the result does not even come close the the data that I expect to get back.

Sometimes $countries and/or $category can only have one element.

That is because of how arrays in PHP work, you are overwriting the terms key each time — Sammaye
– Sammaye, Commented Dec 28, 2013 at 19:45

Sammaye · Accepted Answer · 2013-12-28 19:53:42Z

5

It is becaue of how PHP arrays work, you are overwriting the terms query each time, instead try something along the lines of:

array(
    'body' => array('query' => 
    'bool' => array(
        'must' => array(
            array('terms' => array('country' => implode(' ', $countries))),
            array('terms' => array('category' => implode(' ', $category))),
        )
    )
))

minimum_should_match is useless with must clause of the query.

edited Dec 28, 2013 at 19:53

answered Dec 28, 2013 at 19:47

Sammaye

44k7 gold badges110 silver badges149 bronze badges

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

4 Comments

Marc Witteveen Over a year ago

"you are overwriting the terms query each time" - so obvious. Thanks @Sammaye.

Marc Witteveen Over a year ago

As a side note This: array('country' => implode(' ', $countries)) does not seem to work, but array('country' => $countries) goes fine.

Happy Coder Over a year ago

Is it possible to specify an array there without imploding it ?

Sammaye Over a year ago

@HappyCoder I don' believe so, it was one of the things that confused me about ES: that you culd not query by tjhe structure of it's own schema, among other things

Collectives™ on Stack Overflow

ElasticSearch and searching on multiple fields in PHP

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related