批量插入：
POST consultation/_bulk{"index":{"_index":"consultation", "_type":"_doc", "_id": 1539943}}{"id": 1539943,"createdOn": "2021-12-24 17:47:34","consultNumber": "CN-202112241747HVWN","consultType": "ImageText","inquiryTimes": 2,"hasInquiryTimes": 2,"consultState": "return","overtimeRemindTimes": 0,"purchaseTimes": 2,"hasPurchaseTimes": 2,"overtime": "2021-12-25 17:47:34","completetime": "2021-12-25 17:47:34","membershipLevel": 100,"serviceMoneyListId": 11021,"consultantID": 0,"userId": "ug9lqaP@qIV6Duyy:*2iY","consultantName": "幻惑之风","doctorName": "幻惑之风","patientID": 2029725,"patientName": "123456","age": "17岁8月","sex": 1,"hasReply": false,"inquiryPurchaseCnt": 0,"authorise": false,"departmentId": 0,"serviceState": "normal","expectExpire": false,"callStatus": false,"hasRemark": false,"merchantInfo": {"merchantId": "2BEE2FF0"},"iiinessType": "先天性心脏病","iiinessDescription": "hfjdnd","doctorID": "ug9lqaP@qIV6Duyy:*2iY","isInquiry": false,"isRTAuthorize": false}{"index":{"_index":"consultation", "_type":"_doc", "_id": 1539898}}{"id": 1539898,"createdOn": "2021-12-24 10:16:23","consultNumber": "CN-202112241016PSva","consultType": "ImageText","inquiryTimes": 2,"hasInquiryTimes": 2,"consultState": "return","overtimeRemindTimes": 0,"purchaseTimes": 2,"hasPurchaseTimes": 2,"overtime": "2021-12-25 10:16:23","completetime": "2021-12-25 10:16:23","membershipLevel": 100,"serviceMoneyListId": 11021,"consultantID": 0,"userId": "ug9lqaP@qIV6Duyy:*2iY","consultantName": "幻惑之风","doctorName": "幻惑之风","patientID": 2029725,"patientName": "123456","age": "17岁8月","sex": 1,"hasReply": false,"inquiryPurchaseCnt": 0,"authorise": false,"departmentId": 0,"serviceState": "normal","expectExpire": false,"callStatus": false,"hasRemark": false,"merchantInfo": {"merchantId": "2BEE2FF0"},"iiinessType": "先天性心脏病","iiinessDescription": "hfjdnd","doctorID": "ug9lqaP@qIV6Duyy:*2iY","isInquiry": false,"isRTAuthorize": false}
查询所有索引：
GET _cat/indices?v
查询索引配置：
GET /video_v1/_settings
查询索引字段映射：
GET entry_v1/_mapping
插入索引并设置映射：
PUT consultation_v1{ "mappings": { "properties": { "consultationReplyList": { "type": "nested", "properties": { "repayIllnessDescription": { "type": "text", "analyzer": "ik_max_word" } } }, "age": { "type": "text", "analyzer": "ik_max_word" }, "authorise": { "type": "boolean" }, "completetime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "consultNumber": { "type": "keyword" }, "consultState": { "type": "keyword" }, "consultType": { "type": "keyword" }, "consultantID": { "type": "long" }, "consultantName": { "type": "text", "analyzer": "ik_max_word" }, "createdBy": { "type": "long" }, "createdOn": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "deleteBy": { "type": "long" }, "deleteTime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "doctorCode": { "type": "keyword" }, "doctorID": { "type": "long" }, "doctorName": { "type": "text", "analyzer": "ik_max_word" }, "hasInquiryTimes": { "type": "long" }, "hasPurchaseTimes": { "type": "long" }, "hasReply": { "type": "boolean" }, "iIInessDescription": { "type": "text", "analyzer": "ik_max_word" }, "iIInessType": { "type": "text", "analyzer": "ik_max_word" }, "id": { "type": "long" }, "inquiryTimes": { "type": "long" }, "isDelete": { "type": "boolean" }, "isevaluate": { "type": "boolean" }, "isReturnVisit": { "type": "boolean" }, "modifyBy": { "type": "long" }, "modifyOn": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "orderType": { "type": "long" }, "overtime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "overtimeRemindTimes": { "type": "long" }, "patientCity": { "type": "text", "analyzer": "ik_max_word" }, "patientID": { "type": "long" }, "patientName": { "type": "text", "analyzer": "ik_max_word" }, "phoneNumber": { "type": "text", "analyzer": "ik_max_word" }, "platform": { "type": "keyword" }, "purchaseTimes": { "type": "long" }, "questionsDescription": { "type": "text", "analyzer": "ik_max_word" }, "recommendDoctorCode": { "type": "keyword" }, "recommendDoctorID": { "type": "long" }, "recommendDoctorName": { "type": "text", "analyzer": "ik_max_word" }, "refundBy": { "type": "long" }, "refundNumber": { "type": "text", "analyzer": "ik_max_word" }, "refundReason": { "type": "text", "analyzer": "ik_max_word" }, "refundRemarks": { "type": "text", "analyzer": "ik_max_word" }, "refundState": { "type": "keyword" }, "refundTime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "refundTitle": { "type": "text", "analyzer": "ik_max_word" }, "refundType": { "type": "keyword" }, "returnVisit": { "type": "text", "analyzer": "ik_max_word" }, "returnVisitTime": { "type": "date", "format": "yyyy-MM-dd HH:mm:ss" }, "serviceMoneyListId": { "type": "long" }, "tipsed": { "type": "boolean" }, "userDelete": { "type": "boolean" }, "userId": { "type": "keyword" } } }}
复合查询：
GET consultation/_search{ "query": { "bool": { "must": [ { "term": { "doctorCode": { "value": "o9~*-HRwHV6bZCQADtaOY" } } }, { "term": { "isDelete": false } }, { "bool": { "should": [ { "term": { "consultState": { "value": "return" } } }, { "bool": { "must": [ { "term": { "hasReply": { "value": true } } }, { "term": { "consultState": { "value": "success" } } } ] } }, { "bool": { "must": [ { "term": { "hasReply": { "value": true } } }, { "term": { "consultState": { "value": "commentexpire" } } } ] } } ] } }, { "bool": { "should": [ { "nested": { "path": "consultationReplyList", "query": { "term": { "consultationReplyList.repayIllnessDescription": { "value": "开放" } } } } }, { "term": { "iIInessDescription": "开放" } }, { "term": { "iIInessType": "开放" } }, { "term": { "patientName": "开放" } } ] } } ], "must_not": [ { "term": { "consultState": { "value": "commentexpire" } } } ] } }, "from": 0, "size": 200, "sort": [ { "createdOn": { "order": "desc" } } ]}