nested_order.sh

curl -s -XDELETE 'http://localhost:9200/test-idx'
echo
curl -s -XPUT 'http://localhost:9200/test-idx' -d '{
  "settings": {
      "index.number_of_shards" : 1
  },
  "mappings" : {
      "document" : {
        "properties" : {
          "tags" : {
            "type" : "nested",
            "properties" : {
              "tag" : { "type" : "string", "index": "not_analyzed" },
              "active": {"type": "boolean"}
            }
          },
          "title" : { "type" : "string" },
          "category": {"type": "string", "index": "not_analyzed" }
        }
      }
  }
}
'
echo
curl -s -XPUT 'http://localhost:9200/test-idx/document/1' -d '{
    "title": "search engine",
    "category": "page",
    "tags": [{
        "tag": "AAA",
        "active": true
    }, {
        "tag": "111",
        "active": false
    }   
    ]
}'
echo
curl -s -XPUT 'http://localhost:9200/test-idx/document/2' -d '{
    "title": "elastic search",
    "category": "blog",
    "tags": [{
        "tag": "BBB",
        "active": true
    }, {
        "tag": "222",
        "active": false
    }]
}'
echo
curl -s -XPUT 'http://localhost:9200/test-idx/document/3' -d '{
    "title": "lucene",
    "category": "post",
    "tags": [{
        "tag": "CCC",
        "active": true
    }, {
        "tag": "333",
        "active": false
    }]
}'
echo
curl -s -XPOST 'http://localhost:9200/test-idx/_refresh'
echo
echo "boolean: nested first"
curl -s -XGET 'http://localhost:9200/test-idx/document/_search?pretty=true' -d '{
    "query": {     
        "bool": {
            "must": [{
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    }
                }
            }, {
                "text" : {
                    "title": "search"
                }
            }]
        } 
    },
    "facets": { 
        "test" : {
            "terms" : { 
                "field" : "tags.tag"
            },
            "facet_filter": {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    },
                    "join" : false
                }
            },
            "nested" : "tags"
        }
    },
    "fields": ["title"]
}'
echo
echo "boolean: nested last"
curl -s -XGET 'http://localhost:9200/test-idx/document/_search?pretty=true' -d '{
    "query": {     
        "bool": {
            "must": [{
                "text" : {
                    "title": "search"
                }
            }, {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    }
                }
            }]
        } 
    },
    "facets": { 
        "test" : {
            "terms" : { 
                "field" : "tags.tag"
            },
            "facet_filter" : {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    },
                    "join" : false
                }
            },
            "nested": "tags"
        }
    },
    "fields": ["title"] 
}'
echo
echo "boolean: nested in the middle"
curl -s -XGET 'http://localhost:9200/test-idx/document/_search?pretty=true' -d '{
    "query": {     
        "bool": {
            "must": [{
                "text" : {
                    "title": "search"
                }
            }, {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    }
                }
            }, {
                "term" : {
                    "category": "blog"
                }
            }]
        } 
    },
    "facets": { 
        "test" : {
            "terms" : { 
                "field" : "tags.tag"
            },
            "facet_filter" : {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    },
                    "join" : false
                }   
            },
            "nested": "tags"
        }
    },
    "fields": ["title"] 
}'
echo
echo "filtered: nested as filter"
curl -s -XGET 'http://localhost:9200/test-idx/document/_search?pretty=true' -d '{     
    "query" : {
        "filtered" : {
            "query": {
                "text" : {
                    "title": "search"
                }
            },
            "filter": {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    }
                }                             
            }
        }
    },
    "facets": { 
        "test" : {
            "terms" : { 
                "field" : "tags.tag"
            },
            "facet_filter" : {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    },
                    "join" : false
                }      
            },  
            "nested": "tags"
        } 
    },
    "fields": ["title"]    
}'
echo
echo "filtered: nested as query"
curl -s -XGET 'http://localhost:9200/test-idx/document/_search?pretty=true' -d '{     
    "query" : {
        "filtered" : {
            "query": {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    }
                }                
            },
            "filter": {
                "query": {
                    "term": {
                        "title": "search"
                    }
                }
            }
        }
    },
    "facets": { 
        "test" : {
            "terms" : { 
                "field" : "tags.tag"
            },
            "facet_filter" : {
                "nested" : {
                    "path": "tags",
                    "query": {
                        "term": {
                            "tags.active": true
                        }
                    },
                    "join" : false
                }
            },
            "nested": "tags"
        } 
    },
    "fields": ["title"]    
}'
echo