ElasticSearch: Query on multiple fields

Question

I am new to ElasticSearch and I am trying to query on multiple fields of a a nested document. It actually succeeds only when there is an exact match.

return Record::search()
            ->multiMatch([
                'original_name',
                'some_id',
                'contributors.name',
                'customNames.custom_name',
            ], ' * '.$searchTerm.' * ', ['fuzziness' => 'AUTO'])
            ->size(500)->get()->hits();

Any ideas?

SQL equivalent would be:

SELECT * FROM WHERE records LIKE '%'.$seachTerm.'%' (plus some extra joins)

Sara Vaseei · Accepted Answer · 2019-03-10 09:53:39Z

1

 $query = [
            'multi_match' => [
                'query' => $searchTerm,
               'fields' => [
                    'original_name',
                    'some_id'
                ]
             ],
          ];

$records = Record::searchByQuery($query, '', '', $count, $offset, [
                'id' => ['order' => 'desc']
            ]);

answered Mar 10, 2019 at 9:53

Sara Vaseei

8431 gold badge10 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch: Query on multiple fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related