Elasticsearch Example Queries Cheat Sheet

GET customer_index/_count
{
	"query" : {
		"match_all" : {}
	}
}

GET product_index/_search
{
	"size" : 200,
	"query" : {
		"bool" : {
			"must" : [
				{
					"match" : {
						"category" : "Movie"
					}
				}			
			]
		}
	}
}

GET product_index/_search
{
	"size" : 0,
	"aggs" : {
		"category" : {
			"terms" : {
				"field" : "category.keyword",
				"order" : {
					"_key" : "asc"
				}
			}
		}
	}
}

GET product_index/_search
{
	"size" : 200,
	"query" : {
		"bool" : {
			"must_not" : [
				{
					"exists" : {
						"field" : "category"
					}
				}
			],
			"minimum_should_match" : 1,
			"should" : [
				{
					"match" : {
						"product_type" : {
							"query" : "Physical"
						}
					}
				}
			]
		}
	}
}

GET product_index/_search
{
    "size" : 0, 
    "query" : {
        "bool" : {
            "must" : [
                {
                    "match" : {
                        "product_type" : "Physical"
                    }
                },
                {
                    "wildcard" : {
                        "category.keyword" : {
                            "value" : "*DVD*"
                        }
                    }
                }
                
            ]
        }
    },
    "aggs" : {
        "group_by_column" : {
            "terms" : {
                "field" : "category.keyword",
                "size" : 10000
            }
        }
    
    }
}

GET customer_index/_search
{
	"size" : 200,
	"query" : {
		"match_all" : {}
	}
}

GET product_index/_search
{
	"size" : 200,
	"query" : {
		"wildcard" : {
			"name" : {
				"value" : "*DVD*"
			}
		}
	}
}

GET product_index/_search
{
  "size": 200,
  "query": {
    "function_score": {
      "query": {
        "bool": {
          "must": [
            {
              "bool": {
                "minimum_should_match": 1,
                "should": [
                  {
                    "term": {
                      "category.keyword": "Books"
                    }
                  },
                  {
                    "term": {
                      "category.keyword": "Movies"
                    }
                  }
                ]
              }
            }
          ],
          "minimum_should_match": 1,
          "should": [
            {
              "match_phrase": {
                "nameLowercase": "journey"
              }
            },
            {
              "match_phrase": {
                "descriptionLowercase": "journey"
              }
            }
          ]
        }
      },
      "functions": [
        {
          "filter": {
            "bool": {
              "must": [
                {
                  "term": {
                    "nameLowercase.keyword": "journey"
                  }
                }
              ]
            }
          },
          "weight": 3
        },
        {
          "filter": {
            "bool": {
              "must": [
                {
                  "match_phrase": {
                    "nameLowercase": "journey"
                  }
                }
              ]
            }
          },
          "weight": 2
        },
        {
          "filter": {
            "bool": {
              "must": [
                {
                  "match_phrase": {
                    "descriptionLowercase": "journey"
                  }
                }
              ]
            }
          },
          "weight": 1
        }
      ],
      "score_mode": "first",
      "boost_mode": "replace"
    }
  },
  "sort": {
    "_score": {
      "order": "desc"
    }
  }
}