PHP Elasticsearch Query

Question

I am trying to build a small web application to demo elasticsearch's capabilities, but I am running into an issue with my query. My goal is to search a string of keywords over all indexes and fields. What I currently have seems to only search AttachmentBody, as when I search for BugID xyz or AttachmentTitle xyz nothing is displayed. I would greatly appreciate any help you may have to offer!

<?php

require_once 'es/esconnect.php';

if (isset($_GET['q'])){
    $q = $_GET['q'];
    $query = $Client->search([
        'body' =>[
            'query' =>[
                'bool' =>[
                    'should' =>[
                        'match' => ['BugID' => $q],
                        'match' => ['AttachmentTitle' => $q],
                        'match' => ['AttachmentBody' => $q]
                    ]
                ]
            ]
        ]
    ]);

    if($query['hits']['total'] >=1){
        $results = $query['hits']['hits'];
    }
}

?>

BugID: CSCzo56214

AttachmentTitle: 15624_note_21844

AttachmentBody: this is a note

BugID: CSCzo56214

AttachmentTitle: 15624_description_21846

AttachmentBody: this is a description

Working query:

    'body' =>[
        'query' =>[
            'bool' =>[
                'should' => array(
        array('match' => array('BugID' => $q)),
        array('match' => array('AttachmentTitle' => $q)),
        array('match' => array('AttachmentBody' => $q))
    )

Welcome to SO. Please consider adding a Minimal, Complete, and Verifiable example so we can better help you. So if you can share a sample document that should match as well as what $q would be, it'll be easier for people to help. — Val
– Val, Commented Jan 26, 2016 at 3:23
The inner-most array only consists of one element (key: match, value: ['AttachmentBody' => $q]), because each consecutive mention of the same key, overwrites the previous. Without knowing elasticsearch, my best guess is that you want something like: 'match' => ['BugID' => $q, 'AttachmentTitle' => $q, 'AttachmentBody' => $q]. — Yoshi
– Yoshi, Commented Jan 26, 2016 at 13:26
Hi Val, sure. I added it to the initial post. Thanks for the help! Yoshi, I thought that would be the problem too but it throws an exception: [match] query parsed in simplified form, with direct field name, but included more options than just the field name, possibly use its 'options' form, with 'query' element?" — anshanno
– anshanno, Commented Jan 26, 2016 at 14:58
As I said, unfortunately I don't have any experience with elasticsearch. But I'm pretty sure, that you simply have to find the correct query-structure (as elasticsearch requires it). — Yoshi
– Yoshi, Commented Jan 26, 2016 at 15:10

Yoshi · Accepted Answer · 2016-01-26 16:03:51Z

1

Functioning query:

'body' => [
    'query' => [
        'bool' => [
            'should' => [
                ['match' => ['BugID'           => $q]],
                ['match' => ['AttachmentTitle' => $q]],
                ['match' => ['AttachmentBody'  => $q]]
            ]
        ]
    ]
]

edited Jan 26, 2016 at 16:03

Yoshi

54.8k14 gold badges93 silver badges108 bronze badges

answered Jan 26, 2016 at 15:58

anshanno

3544 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

PHP Elasticsearch Query

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