Elastic Search : Querying Index

Alias name: employee

I . Aliases

  _cat/aliases

   get _alias/employee_index

II . Search records

  GET employee_alias/_search
{
   "query": {"match": {
     "location.zipcode: "11123"
   }}
}

 GET employee-primary-xyz/_search
{
   "query": {"match": {
     "location.zipcode: ""
   }}
}

III . Size boolean query

 GET employee/_search
{
    "size": 1000,
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "department": "sales"
          }
        }
      ]
    }
  }
}

IV. Multiple criteria

3. Multiple criteria:

GET employee/_search
{
      "size" : 400,
   "queries": [{"match": {
     "department": "sales"
   }},{"match": {
     "location":"UK"
   }}]
}

4. Delete all records by match query

POST employee/_delete_by_query

{

  "query": {

    "match": {

     "location": "UK"

    }

  }

}

5. Range Query
GET _search
{
    "query": {
        "range" : {
            "age" : {
                "gte" : 10,
                "lte" : 20,
                "boost" : 2.0
            }
        }
    }

}

6.  Range Query for Date
GET _search
{
    "query": {
        "range" : {
            "date" : {
                "gte" : "now-1d/d",
                "lt" :  "now/d"
            }
        }
    }

}

7. Range query for Date with Format 

GET _search
{
    "query": {
        "range" : {
            "born" : {
                "gte": "01/01/2012",
                "lte": "2013",
                "format": "dd/MM/yyyy||yyyy"
            }
        }
    }

}

8. Remove all records from an index

POST EMPLOYEE_INDEX/_delete_by_query

{

  "query" : {

        "match_all" : {}

    }

}

9. Search for some data value
GET /bank/_search
{
  "query": { "match": { "account_number": 20 } }
}

10. Term Query

Term query
get employee/_search
{
  "query": {
    "term" : { "lastName" : "Dane" }
  }
}

12. Querying from multiple indexes

GET employee, department/_search {

}

13. Delete by criteria:

curl -X POST "ES_HOST/employee/_delete_by_query?wait_for_completion=false"  -H 'Content-Type: application/json' -d'

{

  "query": {

    "match": {

      "employeeId": "123456"

    }

  }

}'