2021-04-09 ES 常用查询DSL语法

{
    "size": 100,
    "_source":{
        "includes":["xxx"]
    },
    "query": {
      "bool" : {
        "should": [
            {
               "range":{
                    "gmt_create":{
                        "from":"2021-03-24 14:59:46",
                        "to":"2021-03-24 15:59:46",
                        "format": "yyyy-MM-dd HH:mm:ss"
                      }
                }
            },
            {
              "term": {
                "biz_type": sss
              }
            }
         ]
      }
    }
}

{
    "size":50,
    "sort" : [
      {"xxxxx" : {"order" : "desc"}}
   ],
    "query":{
        "bool":{
            "must":[
                {
                    "term":{
                        "docRelation":{
                            "value":"xx",
                            "boost":1
                        }
                    }
                },
                {
                    "term":{
                        "xxxx":{
                            "value":00,
                            "boost":1
                        }
                    }
                },
                {
                    "term":{
                        "xxxx":{
                            "value":"xxx",
                            "boost":1
                        }
                    }
                },
                {
                    "match":{
                        "xxx.xxx":{
                            "query":"xxx",
                            "operator":"OR",
                            "prefix_length":0,
                            "max_expansions":50,
                            "fuzzy_transpositions":true,
                            "lenient":false,
                            "zero_terms_query":"NONE",
                            "auto_generate_synonyms_phrase_query":true,
                            "boost":1
                        }
                    }
                },
                {
                    "terms":{
                        "xxx":[
                            xx,
                            xxx
                        ],
                        "boost":1
                    }
                },
                {
                    "range":{
                        "xxxx.xxxx":{
                            "from":0,
                            "to":null,
                            "include_lower":true,
                            "include_upper":true,
                            "boost":1
                        }
                    }
                }
            ],
            "filter":[
                {
                    "range":{
                        "gmtCreate":{
                            "from":1633033243000,
                            "to":null,
                            "include_lower":true,
                            "include_upper":true,
                            "boost":1
                        }
                    }
                },
                {
                    "script":{
                        "script":{
                            "source":"doc['xxx'].value/(doc['xxx'].value+doc['xxx'].value) > xxx",
                            "lang":"painless"
                        },
                        "boost":1
                    }
                }
            ],
            "adjust_pure_negative":true,
            "boost":1
        }
    }
}