GET colordata_eureka/baseinfo/_search
{
  "size": 1000,
  "_source": [
    "Campaign",
    "MainBrand",
    "NumberofReplys",
    "replyDate",
    "SearchBrand"
  ],
  "query": {
    "bool": {
      "must_not": [
        {
          "exists": {
            "field": "NumberofReplys"
          }
        }
      ],
      "should": [
        {
          "exists": {
            "field": "Campaign"
          }
        },
        {
          "exists": {
            "field": "MainBrand"
          }
        }
      ],
      "must": [
        {
          "term": {
            "realChannel": {
              "value": "weixin"
            }
          }
        },
        {
          "range": {
            "replyDate": {
              "gte": "2021-11-11 00:00:00",
              "format": "yyyy-MM-dd HH:mm:ss"
            }
          }
        },
        {
          "term": {
            "thread": {
              "value": "0"
            }
          }
        }
      ]
    }
  }
}