ES query

bool_must_term.json

{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "gender": 2
          }
        },
        {
          "term": {
            "countryId": 36
          }
        }
      ]
    }
  }
}

elasticsearch_query.json

    {
        "query": {
            "match_all": {}
        },
        "sort": [{
            "_geo_distance": {
                "location": "48.2354, 2.9745",
                "unit": "km"
            }
        }]
    }

filter_and_geo_sort.json

{
  "query": {
    "filtered": {
      "query": {
        "term": {
          "gender": 2
        }
      },
      "filter": {
        "and": [
          {
            "range": {
              "age": {
                "gte": 10,
                "lte": 20
              }
            }
          },
          {
            "not": {
              "terms": {
                "userId": [
                  1680
                ]
              }
            }
          }
        ]
      }
    }
  },
  "sort": [
    {
      "_geo_distance": {
        "locationCoordinate": "48.2354, 2.9745",
        "unit": "km"
      }
    }
  ]
}

filter_not_terms.json

{
  "query": {
    "filtered": {
      "query": {
        "bool": {
          "must": {
            "term": {
              "countryId": 36
            }
          }
        }
      },
      "filter": {
        "not": {
          "terms": {
            "userId": [
              1678,2
            ]
          }
        }
      }
    }
  }
}

filter_query_geo_sort.json

{
  "query": {
    "filtered": {
      "query": {
        "term": {
          "gender": 2
        }
      },
      "filter": {
        "not": {
          "terms": {
            "userId": [
              1190
            ]
          }
        }
      }
    }
  },
  "sort": [
    {
      "_geo_distance": {
        "locationCoordinate": "48.2354, 2.9745",
        "unit": "km"
      }
    }
  ]
}

filter_query_range_geo_sort.json

{
  "query": {
    "filtered": {
      "query": {
        "term": {
          "gender": 2
        }
      },
      "filter": {
        "range": {
          "age": {
            "gte": 10,
            "lte": 20
          }
        }
      }
    }
  },
  "sort": [
    {
      "_geo_distance": {
        "locationCoordinate": "48.2354, 2.9745",
        "unit": "km"
      }
    }
  ]
}

query_return_fields.json

{
  "fields": [
    "userId",
    "nickName",
    "avatarUrl",
    "gender",
    "age",
    "schoolChnName"
  ],
  "query": {
    "filtered": {
      "query": {
        "term": {
          "gender": 2
        }
      },
      "filter": {
        "and": [
          {
            "range": {
              "age": {
                "gte": 10,
                "lte": 20
              }
            }
          },
          {
            "not": {
              "terms": {
                "userId": [
                  1680
                ]
              }
            }
          }
        ]
      }
    }
  },
  "sort": [
    {
      "_geo_distance": {
        "locationCoordinate": "48.2354, 2.9745",
        "unit": "km"
      }
    }
  ]
}