Elasticsearch one regexp for multiple fields

Question

I'm new to Elasticsearch. I need to write query to find regexp match in one of the fields.

If I'm looking for regexp in one field everything works fine (PHP code):

$data = ['body' => ['query' => ['regexp' => ['abstract' => ".*searchtext.*"]]]];

what to do if I want to find documents in which at least one field satisfies regexp?

This query:

$data = [
  'body' => [
    'query' => [
      'multi_match' => [
        'query' => 'searchtext',
        'fields' => [
          'type',
          'title',
          'abstract',
          'body_text'
        ]
      ]
    ]
  ]
];

only finds documents with whole word "searchtext" match.

Regards, Tomas

Tom1410 · Accepted Answer · 2018-09-26 07:55:13Z

6

Found answer:

$data = [
  'body' => [
    'query' => [
      'bool' => [
        'should' => [
          ['regexp' => ['type' => ".*searchtext.*"]],
          ['regexp' => ['title' => ".*searchtext.*"]],
          ['regexp' => ['abstract' => ".*searchtext.*"]],
          ['regexp' => ['body_text' => ".*searchtext.*"]],
        ]
      ]
    ]
  ]
];

not so elegant as multi_match query, but works.

answered Sep 26, 2018 at 7:55

Tom1410

3771 gold badge5 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch one regexp for 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