should

GET /search-index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "bool": {
            "should": [
              {"match": {"Fixture.Status": 2}}, 
              {"match": {"Fixture.Status": 3}}
            ]
          }
        }
        
      ]
    }
  }
}

should & sort

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

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

should & range

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

GET /search-index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "bool": {
            "should": [
              {"match": {"Fixture.Status": 2}}, 
              {"match": {"Fixture.Status": 3}}
            ]
          }
        }, 
        {
          "range": {
            "Fixture.StartDate": {
              "gte": "2024-06-18T00:00:00",
              "lte": "2024-06-29T00:01:00"
            }
          }
        }
      ]
    }
  }
}