Elasticsearch Query Example.

query.py

import json
from pprint import pprint
from elasticsearch import Elasticsearch  # pip install elasticsearch

host = 'corpus.metaswitch.com'
es = Elasticsearch(hosts=[host])

query = {
  "_source": ["html", "id", "subject", "breadcrumbs.title", "replyCount" ],
  "size" : 100,
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "replyCount": {
              "gte": 1
            }
          }
        },
        {
          "term": {
            "archived": False
          }
        },
        {
         "nested": {
            "path": "breadcrumbs",
            "query": {
              "match": {
                "breadcrumbs.title": "Mosaic"
              }
            }
          }
        }
      ]
    }
  }
}

results = es.search(index="document", doc_type='communities', body=query)
for result in results['hits']['hits']:
    print "%(replyCount)s\tDOC-%(id)s\t%(subject)s." % result['_source']