Elastic Search with laravel for multiple fields

Question

I have integrated elastic search in laravel with help of below tutorial.

https://appdividend.com/2018/06/30/laravel-elasticsearch-tutorial-example/

According to this tutorial search with single fields is working fine. i.e.

// Article table has column 'title','body' and 'tags'.

 Route::get('/search', function() {
      $articles = Article::searchByQuery(['match' => ['title' => 'Test']]);
      return $articles;
 });

But i want to search with multiple column values like 'title' ,'body' etc.

Anyone suggest an idea how to search with multiple column?

Lucas Luan de Melo · Accepted Answer · 2025-08-29 18:40:14Z

5

You can use the multimatch query, below is some sample how this can be done.

GET _search
{
    "query": {
        "bool": {
            "must": {
              "multi_match" : {
                "query": "stuff you want to seach", 
                "type":  "cross_fields",
                "fields": [ 
                   "title^10",
                   "body^9",
                   "tags^8"
                ]
              }
            }
        }
    }
}

edited Aug 29 at 18:40

answered Oct 8, 2018 at 13:18

Lucas Luan de Melo

1529 bronze badges

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

Comments

Tommy · Accepted Answer · 2020-08-25 17:37:55Z

-2

$array = modelName::searchByQuery(
    [
        'multi_match' => [
            'query' => 'search param', 
            'type' =>  "cross_fields",
            'fields' => [ 
                'field1',
                'field2',
                'more fields'
            ]
        ]
    ]
);

edited Aug 25, 2020 at 17:37

Tommy

2,4731 gold badge25 silver badges51 bronze badges

answered Aug 25, 2020 at 11:21

Manoj Patel

112 bronze badges

1 Comment

Mark Rotteveel Over a year ago

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes.

Collectives™ on Stack Overflow

Elastic Search with laravel for multiple fields

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related