mappingdelete
### deleteDELETE {{host}}/goodscontent-type: application/jsonaccept: application/jsonquery
### mappingGET {{host}}/goodscontent-type: application/jsonaccept: application/jsoncreate
### createPUT {{host}}/goodscontent-type: application/jsonaccept: application/json{"mappings": { "properties": { "goodsId": { "type": "long" }, "goodsName": { "type": "text" }, "goodsNameSort": { "type": "keyword" }, "supTypeId": { "type": "keyword" }, "typeId": { "type": "keyword" }, "products": { "type": "nested", "properties": { "productSapId": { "type": "keyword" }, "name": { "type": "text" }, "priceSort": { "type": "integer" }, "priceRdSapIds": { "type": "keyword" }, "tagsSort": { "type": "integer" }, "tags": { "type": "nested", "properties": { "tagId": { "type": "long" }, "sort": { "type": "integer" }, "startTime": { "type": "date", "format": "yyyy-MM-dd" }, "endTime": { "type": "date", "format": "yyyy-MM-dd" } } }, "promotions": { "type": "nested", "properties": { "promotionId": { "type": "long" }, "rdSapIds": { "type": "keyword" }, "promotionType": { "type": "keyword" }, "startTime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis" }, "endTime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis" } } }, "stocks": { "type": "nested", "properties": { "stockId": { "type": "keyword" }, "stock": { "type": "integer" }, "stockWeek": { "type": "integer" }, "stock14Days": { "type": "integer" }, "stockMonth": { "type": "integer" } } }, "isHot": { "type": "keyword" } } } }}}search### filterPOST {{host}}/goods/_searchcontent-type: application/jsonaccept: application/json{ "explain": true, "query": { "bool": { "must": [ { "terms": { "supTypeId": [ 1 ] } }, { "terms": { "typeId": [ 2 ] } }, { "nested": { "path": "products", "query": { "bool": { "must": [ { "nested": { "path": "products.tags", "query": { "terms": { "products.tags.tagId": [ 4001 ] } } } }, { "terms": { "products.priceRdSapIds": [ 3001 ] } }, { "nested": { "path": "products.stocks", "query": { "script": { "script": "for (int i=0;i<doc['products.stocks.stock'].length;i++){if(doc['products.stocks.stock'][i]>0)return true;}return false;" } } } } ] } } } } ] } }, "sort": [ { "products.tagsSort": { "order": "desc", "mode": "sum", "nested": { "path": "products" } } } ]}test data### 1001:全副POST {{host}}/goods/_doc/1001content-type: application/jsonaccept: application/json{ "goodsId": 1001, "goodsName": "1001", "goodsNameSort": "1001", "supTypeId": [ 1 ], "typeId": [ 2 ], "products": [ { "productSapId": 2001, "name": "2001", "priceRdSapIds": [ 3001 ], "tagsSort": 1, "tags": [ { "tagId": 4001, "sort": 1 } ], "stocks": [ { "stockId": 1, "stock": 0, "stockWeek": 0, "stock14Days": 0, "stockMonth": 0 }, { "stockId": 10, "stock": 1, "stockWeek": 0, "stock14Days": 0, "stockMonth": 0 } ] }, { "productSapId": 2002, "name": "2002", "tagsSort": 2, "tags": [ { "tagId": 3, "sort": 2 } ], "stocks": [ { "stockId": 2, "stock": 1, "stockWeek": 0, "stock14Days": 0, "stockMonth": 0 } ] } ]}