Search result in Symfony project with Elasticsearch

Question

Problem:

I have the following problem. I'm able to search through my data with the SKU. But since there are multiple distributors I want to filter on SKU & distributor. But how can I do that, what I have so far is

PHP

$finder = $this->getContainer()->get('fos_elastica.finder.product.productstock');
$query = new \Elastica\Query\MultiMatch();
$query->setFields(["sku", "distributor"]);
$query->setQuery('XXXXXX');
$productStock = $finder->find($query);
dump($query);
dump($productStock);exit;

$query dump:

Elastica\Query\MultiMatch {#900
  #_params: array:2 [
    "fields" => array:2 [
      0 => "sku"
      1 => "distributor"
    ]
    "query" => "XXXXXXXX"
  ]
  #_rawParams: []
}

Query result:

array:2 [
  0 => AppBundle\Entity\ProductStock {#970
    -id: 16218
    -sku: "XXXXXX"
    -stock: 90
    -price: "11.00"
    -distributor: "XXX"
  }
  1 => AppBundle\Entity\ProductStock {#938
    -id: 54086
    -sku: "XXXXXX"
    -stock: 25
    -priceOverride: "11.00"
    -distributor: "XXX"   
  }
]

Database table ProductStock

+---+-----+------+--------+-------+
|id | sku |stock | vendor | price |
+---+-----+------+--------+-------+

My goal what I want to achieve is to get 1 array from my Elasticsearch result if the SKU and distributor has a match.

Yassine CHABLI · Accepted Answer · 2019-04-18 23:27:46Z

1

You need to set type of the query :

$query->setType(self::TYPE_BEST_FIELDS);
$query->setOperator(self::OPERATOR_AND);

If this not work :

$query->setType(self::TYPE_MOST_FIELDS);

Explanation :

The most_fields type is most useful when querying multiple fields that contain the same text analyzed in different way

check more details here

edited Apr 18, 2019 at 23:27

answered Apr 18, 2019 at 15:22

Yassine CHABLI

3,7822 gold badges28 silver badges47 bronze badges

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

3 Comments

Noob Over a year ago

This still gives me multiple results which is not the idea. It should return 1 result since sku and distributor matches only 1 distributor.

Yassine CHABLI Over a year ago

add $query->setOperator(self::OPERATOR_AND);

Noob Over a year ago

Thx for your response and help so far. But the result from this is not the expected result. SKU & Distributor are two different columns in the database and If I am not wrong its not possible to search for both fields with two queries.

Collectives™ on Stack Overflow

Search result in Symfony project with Elasticsearch

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related