https://www.elastic.co/guide/cn/elasticsearch/guide/current/_wildcard_and_regexp_queries.html
{
"query": {
"wildcard" : {
"content" : "?100543*"
}
},
"from": 0,
"size": 10,
"sort": []
}{
"query": {
"regexp" : {
"content" : "100543[0-9].+"
}
},
"from": 0,
"size": 10,
"sort": []
}{
"took": 7,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 6,
"max_score": 1,
"hits": [
{
"_index": "csc-case",
"_type": "case-info",
"_id": "29928718",
"_score": 1,
"_source": {
"dataObject_144": "110054304",
"latest_dataobject_144_scn": 1757563406985,
"_case_dtc_144_binlog_uptime": 1533785639000,
"_case_dtc_144_database_uptime": 1533785639000,
"_case_dtc_144_uptime": 1533785639128,
"caseId": "29928718",
"caseTypeId": "273",
"questionId": "30766",
"addTime": 1533785639000,
"subSource": "-1",
"creatorId": "18083",
"businessId": "34",
"businessName": null,
"fifthCategoryId": null,
"orderTypeId": "116",
"memo": null,
"fourthCategoryId": null,
"source": "1",
"ownerId": "10385",
"questionTypeId": "1505",
"content": "门店id：110054304 门店名称：绯丽克斯自助餐厅\n商家来电说bd说我这边涉及到套现给我把交易渠道关闭了，我们这边都正常交易的怎么可能会套现，告知可能出现了大额交易这边给您停了，这边您提供材料帮您去恢复，商家不认可，表示要求给他满意的答复。",
"priorityId": "5",
"feedbackTime": null,
"customerType": "51",
"questionReasonId": "7049",
"updaterId": "10385",
"closerId": "10385",
"closeTime": 1534842846000,
"contactNumber": "[\"\",\"15648115588\"]",
"customerId": "110054304",
"bizId": null,
"startTime": 1534842680000,
"nameSpace": null,
"deadline": 1534929080000,
"flowId": "233",
"latest_main_es_update_time": 1534842846119,
"updateTime": 1534842846000,
"managerId": "10385",
"latest_main_scn": 2852910537408,
"statusId": "2",
"nodeId": "38352",
"lifeCycle": "5",
"caseStatistics_reopenCount": 4,
"caseStatistics_callOutCount": 8,
"caseStatistics_lastAttachmentTime": null,
"latest_statistics_update_time": 1534842843088,
"latest_statistics_db_update_time": 1534842843000,
"caseStatistics_refundSuccessCount": 0,
"lastest_statistics_scn": 2852909403857,
"caseStatistics_attachmentCount": 0,
"caseStatistics_latestAttachmentStaffId": null,
"caseStatistics_urgeCount": 0,
"caseStatistics_lastCommentTime": 1534842843000,
"caseStatistics_smsCount": 0,
"caseStatistics_latestReopenStaffId": 10385,
"caseStatistics_commentCount": 12,
"caseStatistics_chatCount": 0,
"caseStatistics_refundInvokeCount": 0,
"caseStatistics_callInCount": 1,
"caseStatistics_pushCount": 0,
"caseStatistics_refundAmountCount": 0,
"caseStatistics_latestReopenTime": 1534842680000,
"caseStatistics_lastCommentStaffId": 10385,
"caseStatistics_elephantCount": 0,
"caseStatistics_emailCount": 0,
"caseStatistics_refundSubmitCount": 0,
"latest_extend_433_scn": 1760970268616,
"_case_extend_433_binlog_uptime": 1533785912000,
"_case_extend_433_uptime": 1533785912274,
"caseExtend_433": "否",
"_case_extend_433_last_uptime": 1533785912000,
"caseExtend_446": "否",
"_case_extend_446_last_uptime": 1533785912000,
"_case_extend_446_binlog_uptime": 1533785912000,
"_case_extend_446_uptime": 1533785912308,
"latest_extend_446_scn": 1760970268616,
"latest_extend_2_scn": 2740464127303,
"_case_extend_2_uptime": 1534741172235,
"caseExtend_2": "18088",
"_case_extend_2_binlog_uptime": 1534741171000,
"_case_extend_2_last_uptime": 1534741172000,
"_case_extend_5_uptime": 1534829584623,
"latest_extend_5_scn": 2830714904183,
"caseExtend_5": "致电商家 (15648115588) 已经联系bd去催促风控 安抚商家等等 结案\n\n\n致电商家先生 15648115588，告知把费率调整成0.38%可以正常使用，商家认可 再次致电先生 15648115588，告知错误费率，重新告知， 认可\n商家需求：可以正常使用后，第一时间告知商家\n大象报备BD，BD表示系统存的商家负责人是错误的，来电15648115588是商家负责人",
"_case_extend_5_last_uptime": 1534829584000,
"_case_extend_5_binlog_uptime": 1534829584000,
"labels": [
{
"tagCategory": "三级风险",
"tagCode": "10",
"extra": "电话联络次数：9，在线联络次数0，在线提交次数：0",
"tagName": "联络次数大于3",
"tagCategoryCode": "3",
"tagSource": "1"
},
{
"tagCategory": "三级风险",
"tagCode": "11",
"extra": "重开次数：4",
"tagName": "重开大于2次",
"tagCategoryCode": "3",
"tagSource": "1"
}
]
}
},
{
"_index": "csc-case",
"_type": "case-info",
"_id": "58640749",
"_score": 1,
"_source": {
"orderId": "[\"517198\"]",
"dataObject_10": "517198",
"latest_dataobject_10_scn": 21523031422962,
"_case_dtc_10_binlog_uptime": 1549337131000,
"_case_dtc_10_database_uptime": 1549337132000,
"_case_dtc_10_uptime": 1549337132058,
"caseId": "58640749",
"caseExtend_767": "",
"_case_extend_767_last_uptime": 1549337132000,
"latest_extend_767_scn": 21523031422962,
"_case_extend_767_uptime": 1549337132073,
"_case_extend_767_binlog_uptime": 1549337131000,
"_case_extend_5_uptime": 1549338636659,
"latest_extend_5_scn": 21527095400579,
"caseExtend_5": "（部分必填）关键处理过程]（账号、投诉、索赔和退款类诉求必须要写，其他的不需要）：核实截图\n\n（必填）解决方案：已反馈申请解封\n（必填）解决方案客户是否认可]（是、否）：是\n（选填）注意事项（客户有特殊的身份；高危问题）：",
"_case_extend_5_last_uptime": 1549338636000,
"_case_extend_5_binlog_uptime": 1549338636000,
"caseTypeId": "407",
"questionId": "33926",
"addTime": 1549337132000,
"subSource": "-1",
"creatorId": "21226",
"businessId": "56",
"businessName": null,
"fifthCategoryId": null,
"orderTypeId": "350",
"memo": null,
"fourthCategoryId": null,
"source": "1",
"ownerId": "21226",
"questionTypeId": "15850",
"content": "（选填）背景：骑手反馈商家未营业，取消订单被限制接单了\n订单：8100543311408772；8100541763437644；8100542599291491\n（必填）诉求：解封",
"priorityId": "5",
"feedbackTime": null,
"customerType": "3001",
"questionReasonId": null,
"updaterId": "21226",
"closerId": "21226",
"closeTime": 1549338636000,
"contactNumber": "[\"\",\"15968839263\"]",
"customerId": "517198",
"bizId": null,
"startTime": 1549337132000,
"nameSpace": null,
"deadline": 1549423532000,
"flowId": "334",
"latest_main_es_update_time": 1549338636717,
"updateTime": 1549338636496,
"managerId": "21226",
"latest_main_scn": 21527095400579,
"statusId": "2",
"nodeId": "80555",
"lifeCycle": "1",
"caseStatistics_reopenCount": 0,
"caseStatistics_callOutCount": 0,
"caseStatistics_lastAttachmentTime": null,
"latest_statistics_update_time": 1549337132699,
"latest_statistics_db_update_time": 1549337133000,
"caseStatistics_refundSuccessCount": 0,
"lastest_statistics_scn": 21523031807672,
"caseStatistics_attachmentCount": 0,
"caseStatistics_latestAttachmentStaffId": null,
"caseStatistics_urgeCount": 0,
"caseStatistics_lastCommentTime": null,
"caseStatistics_smsCount": 0,
"caseStatistics_latestReopenStaffId": null,
"caseStatistics_commentCount": 0,
"caseStatistics_chatCount": 0,
"caseStatistics_refundInvokeCount": 0,
"caseStatistics_callInCount": 1,
"caseStatistics_pushCount": 0,
"caseStatistics_refundAmountCount": 0,
"caseStatistics_latestReopenTime": null,
"caseStatistics_lastCommentStaffId": null,
"caseStatistics_elephantCount": 0,
"caseStatistics_emailCount": 0,
"caseStatistics_refundSubmitCount": 0,
"_case_extend_167_binlog_uptime": 1549337132000,
"_case_extend_167_uptime": 1549337132432,
"caseExtend_167": "众包",
"latest_extend_167_scn": 21523031695166,
"_case_extend_167_last_uptime": 1549337132000,
"latest_extend_816_scn": 21527095400579,
"_case_extend_816_last_uptime": 1549338636000,
"caseExtend_816": "1",
"_case_extend_816_binlog_uptime": 1549338636000,
"_case_extend_816_uptime": 1549338636618,
"_case_extend_6_uptime": 1549338636628,
"latest_extend_6_scn": 21527095400579,
"caseExtend_6": "[\"项辉\",\"15968839263\"]",
"_case_extend_6_last_uptime": 1549338636000,
"_case_extend_6_binlog_uptime": 1549338636000
}
},
{
"_index": "csc-case",
"_type": "case-info",
"_id": "54038955",
"_score": 1,
"_source": {
"orderId": "[\"82402\"]",
"dataObject_145": "82402",
"latest_dataobject_145_scn": 15488054876823,
"_case_dtc_145_binlog_uptime": 1546576787000,
"_case_dtc_145_database_uptime": 1546576787000,
"_case_dtc_145_uptime": 1546576787168,
"caseId": "54038955",
"caseExtend_767": "",
"_case_extend_767_last_uptime": 1546576787000,
"latest_extend_767_scn": 15488054876823,
"_case_extend_767_uptime": 1546576787180,
"_case_extend_767_binlog_uptime": 1546576787000,
"_case_extend_5_uptime": 1546576846956,
"latest_extend_5_scn": 15488088634141,
"caseExtend_5": "关键判断：\n处理结果：告知联系bd换机，未满足需求，认可\n注意事项：",
"_case_extend_5_last_uptime": 1546576847000,
"_case_extend_5_binlog_uptime": 1546576846000,
"caseExtend_446": "否",
"_case_extend_446_last_uptime": 1546576787000,
"_case_extend_446_binlog_uptime": 1546576787000,
"_case_extend_446_uptime": 1546576787236,
"latest_extend_446_scn": 15488054876823,
"latest_extend_433_scn": 15488054876823,
"_case_extend_433_binlog_uptime": 1546576787000,
"_case_extend_433_uptime": 1546576787264,
"caseExtend_433": "否",
"_case_extend_433_last_uptime": 1546576787000,
"caseTypeId": "1550",
"questionId": "6094",
"addTime": 1546576787000,
"subSource": "-1",
"creatorId": "18089",
"businessId": "34",
"businessName": null,
"fifthCategoryId": null,
"orderTypeId": "114",
"memo": null,
"fourthCategoryId": null,
"source": "1",
"ownerId": "18086",
"questionTypeId": "1031",
"content": "门店ID：110054304\n设备类型（POS/盒子/音箱）：\nsn码：83949203\n商家名称：绯丽克斯自助餐厅\n商家问题（需具体描述）：按键没反应\n商户需求：",
"priorityId": "11",
"feedbackTime": null,
"customerType": "51",
"questionReasonId": "1411",
"updaterId": "18086",
"closerId": "18086",
"closeTime": 1546577759000,
"contactNumber": "[\"\",\"13354880281\"]",
"customerId": "110054304",
"bizId": null,
"startTime": 1546577179000,
"nameSpace": null,
"deadline": 1546836379000,
"flowId": "1246",
"latest_main_es_update_time": 1546577759240,
"updateTime": 1546577759086,
"managerId": "18086",
"latest_main_scn": 15488581501705,
"statusId": "2",
"nodeId": "92991",
"lifeCycle": "2",
"caseStatistics_reopenCount": 1,
"caseStatistics_callOutCount": 1,
"caseStatistics_lastAttachmentTime": null,
"latest_statistics_update_time": 1546577757203,
"latest_statistics_db_update_time": 1546577757000,
"caseStatistics_refundSuccessCount": 0,
"lastest_statistics_scn": 15488580437823,
"caseStatistics_attachmentCount": 0,
"caseStatistics_latestAttachmentStaffId": null,
"caseStatistics_urgeCount": 0,
"caseStatistics_lastCommentTime": 1546577757000,
"caseStatistics_smsCount": 0,
"caseStatistics_latestReopenStaffId": 18086,
"caseStatistics_commentCount": 2,
"caseStatistics_chatCount": 0,
"caseStatistics_refundInvokeCount": 0,
"caseStatistics_callInCount": 1,
"caseStatistics_pushCount": 0,
"caseStatistics_refundAmountCount": 0,
"caseStatistics_latestReopenTime": 1546577179000,
"caseStatistics_lastCommentStaffId": 18086,
"caseStatistics_elephantCount": 0,
"caseStatistics_emailCount": 0,
"caseStatistics_refundSubmitCount": 0
}
},
{
"_index": "csc-case",
"_type": "case-info",
"_id": "19911461",
"_score": 1,
"_source": {
"orderId": "[\"51005621\",\"43136172\"]",
"dataObject_168": "51005621",
"latest_dataobject_168_scn": 8242574255260,
"_case_dtc_168_binlog_uptime": 1528110883000,
"_case_dtc_168_database_uptime": 1528110884000,
"_case_dtc_168_uptime": 1528110883901,
"caseId": "19911461",
"latest_dataobject_158_scn": 8242574255260,
"dataObject_158": "43136172",
"_case_dtc_158_binlog_uptime": 1528110883000,
"_case_dtc_158_uptime": 1528110883947,
"_case_dtc_158_database_uptime": 1528110884000,
"_case_extend_6_uptime": 1528110883973,
"latest_extend_6_scn": 8242574255260,
"caseExtend_6": "[\"许先生\",\"15658900201\"]",
"_case_extend_6_last_uptime": 1528110884000,
"_case_extend_6_binlog_uptime": 1528110883000,
"caseTypeId": "466",
"questionId": "7571",
"addTime": 1528110884000,
"subSource": "-1",
"creatorId": "9426",
"businessId": "12",
"businessName": null,
"fifthCategoryId": null,
"orderTypeId": "134",
"memo": null,
"fourthCategoryId": null,
"source": "1",
"ownerId": "2084",
"questionTypeId": "772",
"content": "门店ID：170889915\t初源炸鸡\n合同编号\tDDCY059223337356 \n项目ID：51005621、51005437、51005054、51052703\n辛苦设置不可购买，商家联系bd让联系总部\n辛苦核实并回复商家",
"priorityId": "5",
"feedbackTime": null,
"customerType": "2007",
"questionReasonId": "3732",
"updaterId": "2084",
"closerId": "2084",
"closeTime": 1528114086000,
"contactNumber": "[\"\",\"15658900201\"]",
"customerId": "43136172",
"bizId": null,
"startTime": 1528110884000,
"nameSpace": null,
"deadline": 1528197284000,
"flowId": "240",
"latest_main_es_update_time": 1528114086920,
"updateTime": 1528114086000,
"latest_main_scn": 8246573122250,
"statusId": "2",
"nodeId": "25847",
"lifeCycle": "1",
"caseStatistics_reopenCount": 0,
"caseStatistics_callOutCount": 2,
"caseStatistics_lastAttachmentTime": null,
"latest_statistics_update_time": 1528113893297,
"latest_statistics_db_update_time": 1528113893000,
"caseStatistics_refundSuccessCount": 0,
"lastest_statistics_scn": 8246528939804,
"caseStatistics_attachmentCount": 0,
"caseStatistics_latestAttachmentStaffId": null,
"caseStatistics_urgeCount": 0,
"caseStatistics_lastCommentTime": null,
"caseStatistics_smsCount": 1,
"caseStatistics_latestReopenStaffId": null,
"caseStatistics_commentCount": 0,
"caseStatistics_chatCount": 0,
"caseStatistics_refundInvokeCount": 0,
"caseStatistics_callInCount": 1,
"caseStatistics_pushCount": 0,
"caseStatistics_refundAmountCount": 0,
"caseStatistics_latestReopenTime": null,
"caseStatistics_lastCommentStaffId": null,
"caseStatistics_elephantCount": 0,
"caseStatistics_emailCount": 0,
"caseStatistics_refundSubmitCount": 0,
"_case_extend_5_uptime": 1528113893306,
"latest_extend_5_scn": 8246528949015,
"caseExtend_5": "电话cm陶建军未接通+2，大象告知同意，操作短信告知15658900201",
"_case_extend_5_last_uptime": 1528113893000,
"_case_extend_5_binlog_uptime": 1528113893000
}
},
{
"_index": "csc-case",
"_type": "case-info",
"_id": "29993673",
"_score": 1,
"_source": {
"dataObject_144": "110054304",
"latest_dataobject_144_scn": 1791719832966,
"_case_dtc_144_binlog_uptime": 1533803883000,
"_case_dtc_144_database_uptime": 1533803883000,
"_case_dtc_144_uptime": 1533803883201,
"caseId": "29993673",
"caseTypeId": "273",
"questionId": "30766",
"addTime": 1533803883000,
"subSource": "-1",
"creatorId": "18084",
"businessId": "34",
"businessName": null,
"fifthCategoryId": null,
"orderTypeId": "116",
"memo": null,
"fourthCategoryId": null,
"source": "1",
"ownerId": "5636",
"questionTypeId": "1505",
"content": "门店ID：110054304\n门店名称\t：绯丽克斯自助餐厅\t\nSN码：83949203\t\n问题：商家来电表示pos机和小白盒都不能进行收款，显示交易失败（微信、支付宝、银行卡都失败）商家希望尽快处理\n商家称呼：侯先生 13354880281",
"priorityId": "5",
"feedbackTime": null,
"customerType": "51",
"questionReasonId": "7049",
"updaterId": "5636",
"closerId": "5636",
"closeTime": 1533810574000,
"contactNumber": "[\"先生\",\"13354880281\"]",
"customerId": "110054304",
"bizId": null,
"startTime": 1533803883000,
"nameSpace": null,
"deadline": 1533890283000,
"flowId": "233",
"latest_main_es_update_time": 1533810574517,
"updateTime": 1533810574000,
"managerId": "18084",
"latest_main_scn": 1804596325118,
"statusId": "2",
"nodeId": "38352",
"lifeCycle": "1",
"caseStatistics_reopenCount": 0,
"caseStatistics_callOutCount": 3,
"caseStatistics_lastAttachmentTime": null,
"latest_statistics_update_time": 1533810571378,
"latest_statistics_db_update_time": 1533810571000,
"caseStatistics_refundSuccessCount": 0,
"lastest_statistics_scn": 1804595220494,
"caseStatistics_attachmentCount": 0,
"caseStatistics_latestAttachmentStaffId": null,
"caseStatistics_urgeCount": 0,
"caseStatistics_lastCommentTime": 1533810571000,
"caseStatistics_smsCount": 0,
"caseStatistics_latestReopenStaffId": null,
"caseStatistics_commentCount": 3,
"caseStatistics_chatCount": 0,
"caseStatistics_refundInvokeCount": 0,
"caseStatistics_callInCount": 1,
"caseStatistics_pushCount": 0,
"caseStatistics_refundAmountCount": 0,
"caseStatistics_latestReopenTime": null,
"caseStatistics_lastCommentStaffId": 5636,
"caseStatistics_elephantCount": 0,
"caseStatistics_emailCount": 0,
"caseStatistics_refundSubmitCount": 0,
"latest_extend_433_scn": 1791849958690,
"_case_extend_433_binlog_uptime": 1533804176000,
"_case_extend_433_uptime": 1533804176509,
"caseExtend_433": "否",
"_case_extend_433_last_uptime": 1533804176000,
"caseExtend_446": "否",
"_case_extend_446_last_uptime": 1533804176000,
"_case_extend_446_binlog_uptime": 1533804176000,
"_case_extend_446_uptime": 1533804176541,
"latest_extend_446_scn": 1791849958690,
"latest_extend_2_scn": 1791849958690,
"_case_extend_2_uptime": 1533804176627,
"caseExtend_2": "18084",
"_case_extend_2_binlog_uptime": 1533804176000,
"_case_extend_2_last_uptime": 1533804176000,
"_case_extend_5_uptime": 1533810574449,
"latest_extend_5_scn": 1804596325118,
"caseExtend_5": "核实被微信风控，支付宝可以使 致电商家侯先生 13354880281 电话未接 已经短信告知结案",
"_case_extend_5_last_uptime": 1533810574000,
"_case_extend_5_binlog_uptime": 1533810574000
}
},
{
"_index": "csc-case",
"_type": "case-info",
"_id": "15974349",
"_score": 1,
"_source": {
"caseExtend_6": "[null,\"15248126689\"]",
"_case_extend_6_last_uptime": 1525422845000,
"_case_extend_6_binlog_uptime": 1525422844000,
"_case_extend_6_uptime": 1525422845038,
"latest_extend_6_scn": 6189999123113,
"caseTypeId": "268",
"questionId": "6684",
"addTime": 1525422845000,
"subSource": "-1",
"creatorId": "1980",
"businessId": "2",
"businessName": null,
"fifthCategoryId": null,
"orderTypeId": "128",
"memo": null,
"fourthCategoryId": null,
"source": "11",
"ownerId": "1980",
"questionTypeId": "1167",
"content": "商户满意度调研\t110054304\t绯丽克斯烧烤涮自助（七彩城店）\t呼和浩特\tC\t到店餐饮销售部\t15248126689",
"priorityId": "5",
"feedbackTime": null,
"customerType": "1003",
"questionReasonId": "2158",
"updaterId": "1980",
"closerId": "1980",
"caseId": "15974349",
"closeTime": 1525430315000,
"contactNumber": "[\"\",null]",
"customerId": "-1",
"bizId": null,
"startTime": 1525422845000,
"nameSpace": null,
"deadline": 1525509245000,
"flowId": "438",
"latest_main_es_update_time": 1525430315194,
"updateTime": 1525430315000,
"latest_main_scn": 6197771150931,
"statusId": "2",
"nodeId": "22197",
"lifeCycle": "1",
"caseStatistics_reopenCount": 0,
"caseStatistics_callOutCount": 1,
"caseStatistics_lastAttachmentTime": null,
"latest_statistics_update_time": 1525422919335,
"latest_statistics_db_update_time": 1525422919000,
"caseStatistics_refundSuccessCount": 0,
"lastest_statistics_scn": 6190013039248,
"caseStatistics_attachmentCount": 0,
"caseStatistics_latestAttachmentStaffId": null,
"caseStatistics_urgeCount": 0,
"caseStatistics_lastCommentTime": 1525422918000,
"caseStatistics_smsCount": 0,
"caseStatistics_latestReopenStaffId": null,
"caseStatistics_commentCount": 1,
"caseStatistics_chatCount": 1,
"caseStatistics_refundInvokeCount": 0,
"caseStatistics_callInCount": 1,
"caseStatistics_pushCount": 0,
"caseStatistics_refundAmountCount": 0,
"caseStatistics_latestReopenTime": null,
"caseStatistics_lastCommentStaffId": 1980,
"caseStatistics_elephantCount": 0,
"caseStatistics_emailCount": 0,
"caseStatistics_refundSubmitCount": 0
}
}
]
}
}
扫一扫
2707
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
