-
查看基本信息(指定索引)
http://{{es-host}}:9200/_cat/indices?format=json&index=gy_order
-
查看基本信息
http://{{es-host}}:9200/_cat/indices?v
-
查看文档, 通过主键
http://{{es-host}}:9200/gy_order/_doc/16086160590000300010235935
-
基本搜索 term
http://{{es-host}}:9200/gy_order/_search
{
"query": {
"term": {
"o_u_id": {
"value": 22123997
}
}
}
}
- multi_match
{
"size": 5,
"query": {
"multi_match": {
"query": " 1473068162199116261",
"fields": ["o_goodsname", "o_ordersn", "o_remark"]
}
}
}
- match_phrase
{
"query": {
"match_phrase": {
"o_goodsname": "食品"
}
}
}
- 复合查询
{
"query": {
"bool": {
"should": [
{
"match": {
"o_goodsname": "007259753302633"
}
},
{
"match": {
"o_ordersn": "007259753302633"
}
}
]
}
},
"from": 0,
"size": 10,
"sort": [],
"aggs": {}
}
- 搜索o_id
{
"query": {
"term": {
"o_id": {
"value": 9370104
}
}
}
}
- 搜索o_u_id
{
"size" : 20,
"query": {
"term": {
"o_u_id": {
"value": 22123997
}
}
}
}
- 搜索o_ordersn
{
"query": {
"term": {
"o_ordersn": {
"value": "408438704802070"
}
}
}
}
- o_ordersn multi_match
{
"multi_match": {
"query": "1473068162199116261",
"fields": [
"o_goodsname",
"o_ordersn",
"o_remark"
]
}
}
- 团队搜索
{
"from": 0,
"size": 10,
"query": {
"bool": {
"should": [
{
"term": {
"o_y_id": {
"value": 22123997,
"boost": 1
}
}
},
{
"term": {
"o_u_s_id": {
"value": 22123997,
"boost": 1
}
}
},
{
"term": {
"o_u_t_id": {
"value": 22123997,
"boost": 1
}
}
}
],
"adjust_pure_negative": true,
"boost": 1
}
},
"sort": [
{
"o_creattime": {
"order": "desc"
}
}
]
}
- 我的本月收益 (o_u_id=?, 月份=12, o_state!=4), aggs(o_u_m)
{
"size": 100,
"_source": ["o_ordersn","o_u_m"],
"query": {
"bool": {
"must": [
{
"term": {
"o_u_id": {
"value": "23066916"
}
}
},
{
"term": {
"_dbTable": {
"value": "db_gylm.tb_tb_order_2020_12"
}
}
}
],
"must_not": [
{
"term": {
"o_state": {
"value": 4
}
}
}
]
}
},
"aggs": {
"result": {
"sum": {
"field": "o_u_m"
}
}
}
}
- 团队的本月收益(o_y_id=?, 月份=12, o_state!=4) aggs(o_y_m)
{
"size": 100,
"_source": ["o_ordersn","o_u_m","o_y_m","o_u_s_m","o_u_t_m"],
"query": {
"bool": {
"must": [
{
"term": {
"o_y_id": {
"value": "22123997"
}
}
},
{
"term": {
"_dbTable": {
"value": "db_gylm.tb_tb_order_2020_12"
}
}
}
],
"must_not": [
{
"term": {
"o_state": {
"value": 4
}
}
}
]
}
},
"aggs": {
"result": {
"sum": {
"field": "o_y_m"
}
}
}
}
- count 我的订单数
{
"query": {
"term": {
"o_u_id": {
"value": 23066916
}
}
}
}
- count 团队订单数
{
"query": {
"bool": {
"should": [
{
"term": {
"o_y_id": {
"value": 22123997
}
}
},
{
"term": {
"o_u_s_id": {
"value": 22123997
}
}
},
{
"term": {
"o_u_t_id": {
"value": 22123997
}
}
}
]
}
}
}
- count 分公司订单数
{
"query": {
"bool": {
"should": [
{
"term": {
"o_b_id": {
"value": 14
}
}
}
]
}
}
}
- 标题
- 标题