retrieving the multivalued array from elasticsearch

Question

I have trouble getting the facet in my index. Basically I want to get the details of particular facet say "Company" in a separate array

I tried many queries but it all get entire facet under facet array .How can I get only particular facet in a facet array

My index is https://gist.github.com/4015817

Please help me .I am badly stuck here

imotov · Accepted Answer · 2012-11-06 00:39:14Z

2

Considering how complex your data structure is, the simples way to extract this information might be using script fields:

curl "localhost:9200/index/doc/_search?pretty=true" -d '{
    "query" : {
        "match_all" : {

        }
    },
    "script_fields": {
        "entity_facets": {
            "script": "result=[];foreach(facet : _source.Categories.Types.Facets) {if(facet.entity==entity) result.add(facet);} result",
            "params": {
                "entity": "Country"
            }

        },
        "first_facet": {
            "script": "_source.Categories.Types.Facets[0]"    
        }

    }
}'

answered Nov 6, 2012 at 0:39

imotov

30.2k3 gold badges93 silver badges87 bronze badges

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

1 Comment

user1790894 Over a year ago

thanks alot imotov. You helped me from a great trouble. Thanks very much .

Collectives™ on Stack Overflow

retrieving the multivalued array from elasticsearch

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related