match

GET /search-index/_search
{
  "query": {
    "match": {
      "Fixture.Status": 2
    }
  }
}

match & sort

https://www.elastic.co/guide/en/elasticsearch/reference/current/sort-search-results.html

GET /search-index/_search
{
  "query": {
    "match": {
      "Fixture.Status": 2
    }
  },
  "sort": [
    {
      "Fixture.StartDate": "asc"
    }
  ]
}

match & range

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html

GET /search-index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "Fixture.Status": 2
          }
        }, 
        {
          "range": {
            "Fixture.StartDate": {
              "gte": "2024-06-19T00:00:00",
              "lte": "2024-06-19T00:03:59"
            }
          }
        }
      ]
    }
  }
}

match & range(filter)

GET /search-index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "Fixture.Status": 2
          }
        }
      ],
      "filter": [
        {
          "range": {
            "Fixture.StartDate": {
              "gte": "2024-06-18T00:00:00",
              "lte": "2024-06-20T23:59:59"
            }
          }
        }
      ]
    }
  }
}