Elasticsearch match multiple fields

Question

I am recently using elasticsearch in a website. The scenario is, I have to search a string on afield. So, if the field is named as title then my search query was,

"query" :{"match": {"title": my_query_string}}.

But now I need to add another field in it. Let say, category. So i need to find the matches of my string which are in category :some_category and which have title : my_query_string I tried with multi_match. But it does not give me the result i am looking for. I am looking into query filter now. But is there way of adding two fields in such criteria in my match query?

How do you define the category? Is it something that the user will specify or something that will be implied? eg. Say you have a bookstore, and the user now browses the "fantasy" category. If he searches you want only to search the titles under this category? — Sakis Vtdk
– Sakis Vtdk, Commented Apr 7, 2014 at 10:28

Kristaps Karlsons · Accepted Answer · 2014-04-07 10:46:12Z

10

GET indice/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "match": {
            "title": "title"
          }
        },
        {
          "match": {
            "category": "category"
          }
        }
      ]
    }
  }
}

Replace should with must if desired.

answered Apr 7, 2014 at 10:46

Kristaps Karlsons

4821 gold badge7 silver badges22 bronze badges

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

Comments

Sakis Vtdk · Accepted Answer · 2014-04-07 11:13:26Z

3

Ok, so I think that what you need is something like this:

"query": {
    "filtered": {
        "query": {
            "match": {
                "title": YOUR_QUERY_STRING,
            }
        },
        "filter": {
            "term": {
                "category": YOUR_CATEGORY
            }
        }
    }
}

If your category field is analyzed, then you will need to use match instead of term in the filter.

edited Apr 7, 2014 at 11:13

answered Apr 7, 2014 at 10:37

Sakis Vtdk

5931 gold badge6 silver badges15 bronze badges

Comments

John Paul Hayes · Accepted Answer · 2016-12-15 23:02:30Z

0

      "query": {
            "filtered": {
                "query": {
                    "bool": {
                        "should": [
                            {"match": {"title": "bold title"},
                            {"match": {"body": "nice body"}}
                        ]
                    }
                },
                "filter": {
                    "term": {
                        "category": "xxx"
                    }
                }
            }
        }

answered Dec 15, 2016 at 23:02

John Paul Hayes

7988 silver badges13 bronze badges

Collectives™ on Stack Overflow

Elasticsearch match multiple fields

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related