Elasticsearch.Net and NEST to search both for a string and array of tags

Question

Having a data like this: { "id" : 22, "name" : "test", "tagIds" : [ 2, 35, 56, 59 ] }, how is it possible to search for both name and tags?

Using following query:

{
  "from": 0,
  "size": 100,  
  "query": {
    "terms": {
      "tagIds": [
        35
      ]
    },  
    "multi_match": {
      "query": "test",
      "fields": [
        "name"
      ]
    }
  }
}

Gets this parsing exception: [terms] malformed query, expected [END_OBJECT] but found [FIELD_NAME]

How to write this correctly in fluent nest?

bittusarkar · Accepted Answer · 2018-05-27 07:26:51Z

1

You need to use bool query for combining multiple queries. Hence, your query should look like below:

{   
    "from": 0,  
    "size": 100,     
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "tagIds": [
                            35
                        ]
                    }
                },
                {
                    "multi_match": {
                        "query": "test",
                        "fields": [
                            "name"
                        ]
                    }
                }
            ]
        }
    }
}

answered May 27, 2018 at 7:26

bittusarkar

6,3674 gold badges36 silver badges51 bronze badges

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

4 Comments

Babak Over a year ago

Thanks, but it doesn't work if tagIds was empty, so I changed must-terms to should-term.

bittusarkar Over a year ago

If you change it to should-term, the logic changes. Now the logic becomes (tags IN [35] OR name = test) instead of (tags IN [35] AND name = test). Is that what you want?

Babak Over a year ago

Then how can I handle if tags was empty but name wasn't?

bittusarkar Over a year ago

This you have to do in the client code itself; Elasticsearch can't help you here much. If tags was empty, then do not even create the query with tags, just create the query with name field.

Collectives™ on Stack Overflow

Elasticsearch.Net and NEST to search both for a string and array of tags

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related