Searching multiple fields in elasticsearch

Question

I'm indexing meta data on files and my mappings looks like this:

curl -XPUT "http://localhost:9200/myapp/" -d '
{
    "mappings": {
        "file": {
            "properties": {
                "name": {
                    "type": "string", "index": "not_analyzed"
                },
                "path": {
                    "type": "string", "index": "not_analyzed"
                },
                "user": {
                    "type": "string", "index": "not_analyzed"
                }
            }
        }
    }
}
'

There are some other fields too, but they are not relevant to this question. Here 'name' is the name of a file, 'path' is the path to the file and user is the owner of that file. When indexing the data could look something like:

{ name: 'foo', path: '/', user: 'dude' }
{ name: 'bar', path: '/subfolder/', user: 'dude' }
{ name: 'baz', path: '/', user: 'someotherdude' }

My question is how to build my query so that I can do folder listings given a path and a user. So searching for the user 'dude' and path '/' should result in 'foo'.

ralphtheninja · Accepted Answer · 2013-08-13 22:39:40Z

5

You can use a bool which allows you to specify the queries that must match to constitute a hit. Your query will look something like this

{
    "query": {
        "bool" : {
            "must" : [ 
                { "match": { "user" : "dude" } },
                { "match": { "path" : "/" } }
            ]
         }
    },
    "fields": ["name"]
}

What this does is checks that there is an exact match for the term "dude" and path "/"

edited Aug 13, 2013 at 22:39

ralphtheninja

134k20 gold badges114 silver badges122 bronze badges

answered Aug 13, 2013 at 16:53

Akshat Jiwan Sharma

16.2k13 gold badges52 silver badges60 bronze badges

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

9 Comments

ralphtheninja Over a year ago

This works fine if I e.g. curl it on command line. Since I'm in a JavaScript environment and build my query objects directly from JS it becomes problematic due to multiple "must" in the "bool" section. Pondering how to get around that. Any suggestions? :)

ralphtheninja Over a year ago

Figured it out. Would be nice if you could update your answer to "must" : [ { "match": { "user" : "dude" } }, { "match": { "path" : "/" } } ]

ralphtheninja Over a year ago

Thanks all to your contributions. It works like a clock here. Very fast and clean! :)

ralphtheninja Over a year ago

It's truly amazing and CRAZY fast!

user378704 Over a year ago

Thanks ! I was looking for something like this

|

Collectives™ on Stack Overflow

Searching multiple fields in elasticsearch

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related