gistfile1.json

Parent document mapping

{
  "parent" : {
    "properties" : {
      "headline" : {
        "type" : "string"
      },
      "doc_score" : {
        "type" : "long"
      },
      "show" : {
        "type" : "boolean"
      }
    }
  }
}

Child document mapping

{
  "child" : {
    "_routing" : {
      "required" : true
    },
    "properties" : {
      "subject_name" : {
        "type" : "string"
      },
      "points" : {
        "type" : "long"
      }
    }
  }
}

Elastic Search Query

{
"query" : {
"filtered" : {
  "query" : {
    "custom_score" : {
      "query" : {
        "has_child" : {
          "type" : "expertise",
          "query" : {
            "flt" : {
              "fields" : ["subject_name"],
              "like_text" : "Finance"
            }
          }
        }
      },
      "script" : "_score * doc['doc_score'].value"
    }
  },
  "filter" : {
    "not" : {
      "term" : {
        "show" : 0
      }
    }
  }
}
},
"size" : 200
}