项目场景：

Elasticsearch模糊查询某字段、多字段in查询、时间范围查询，通过DSL和java API两种方式

---

解决方案： 

一、模糊查询

wildcard 通配符检索

使用wildcard相当于SQL的like，前后都可拼接*，匹配0到多个任意字符

{
    "query": {
        "wildcard": {
            "name.keyword": "*文件*"
        }
    }
}

BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
queryBuilder.must(QueryBuilders.wildcardQuery("name.keyword", "*文件*"));

fuzzy 模糊/纠错检索

使用fuzzy类似百度搜索，你输入“周杰伦”，也能查出来“周杰轮”，有纠错能力

{
    "query": {
        "fuzzy": {
            "name.keyword": "*周杰伦*"
        }
    }
}

BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
queryBuilder.must(QueryBuilders.fuzzyQuery("name.keyword", "周杰伦"));

二、多字段in查询

通过terms实现，类似SQL的in查询，多字段用集合表示

{
  "query": {
    "bool": {
      "must": {
        "terms": {
          "name":[
              "张三",
              "李四"
            ]
        }
      }
    }
  }
}

BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
queryBuilder.must(QueryBuilders.termsQuery("name.keyword", new ArrayList<>()));

三、时间范围查询

from、to为时间范围，include_lower、include_upper为是否包含左右边界

{
  "query": {
    "bool": {
      "must": {
        "range": {
          "createTime": {
            "from": "2022-01-01",
            "to": "2022-03-01",
            "include_lower": true,
            "include_upper": true,
            "boost": 1
          }
        }
      }
    }
  }
}

BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
queryBuilder.must(QueryBuilders.rangeQuery("createTime").gte("2022-01-01").lte("2022-03-01"));