Contracts based on a range intersection where validTo can be null

ES_contracts_for_interval.txt

{
  "size": 9999999,
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "contractAttributions",
            "query": {
              "bool": {
                "must": [
                  {
                    "terms": {
                      "contractAttributions.contractNumber": ["UBI00000094-0003", "UBI00000094-0005"]
                    }
                  }
                ]
              }
            }
          }
        },


        {
          "nested": {
            "path": "contractAttributions",
            "filter": {
              "bool": {
                "must": [
                  {
                    "range": {
                      "contractAttributions.validFrom": {
                        "lte": "2017-01-01T00:00:00.000+01:00"
                      }
                    }
                  }
                ]
              }
            }
          }
        },


        {
          "nested": {
            "path": "contractAttributions",
            "filter": {
              "bool": {
                "should": [
                  {
                    "range": {
                      "contractAttributions.validTo": {
                        "gte": "2015-03-30T00:00:00.000+01:00"
                      }
                    }
                  },
                  {
                    "missing": {
                      "field": "contractAttributions.validTo"
                    }
                  }
                ]
              }
            }
          }
        }


      ]
    }
  }
}