1、订单类型为采购单,商品skuId为集合,并且不在指定门店下面

{
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "skuIds": [
                            100008423842,                       
                            100004807621
                        ]
                    }
                },
                {
                    "term": {
                        "businessType": 1
                    }
                }
            ],
            "must_not": [
                {
                    "terms": {
                        "jdOrderId": [
                            50301785,
                            50318655                        
                        ]
                    }
                }
            ],
            "should": []
        }
    },
    "from": 0,
    "size": 10,
    "sort": [],
    "aggs": {}
}

 

posted on 2019-09-20 13:08  gudicao  阅读(301)  评论(0编辑  收藏  举报