1.json 数据结构如下
{
"took" : 3,
"timed_out" : false,
"_shards" : {
"total" : 6,
"successful" : 6,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 162,
"relation" : "eq"
},
"max_score" : 11.1383505,
"hits" : [
{
"_index" : "sku_goods",
"_type" : "_doc",
"_id" : "3a0530c9-0457-c6f3-5b23-004156cfa44c",
"_score" : 11.1383505,
"_source" : {
"Id" : "3a0530c9-0457-c6f3-5b23-004156cfa44c",
"PartNo" : "105J250CS6G-FA",
"Brand" : "PAKTRON CAPACITORS",
"BrandSource" : "PAKTRON CAPACITORS",
"CategoryId" : "00000000-0000-0000-0000-000000000000",
"Packing" : "管装",
"Describe" : "CS6 系列 250 V 1 uF ±5% 表面贴装 金属化 聚酯 Capstick® 电容",
"ECCN" : "EAR99",
"IsBrandStandard" : false,
"IsCategoryClassify" : false,
"DataSourceType" : "1000",
"CreateTime" : "2022-07-21 10:33:09",
"CreateTimeStamp" : 1658370789,
"CreateUserId" : "00000000-0000-0000-0000-000000000000",
"CreateUserName" : "系统",
"UpdateTime" : "2022-07-21 10:33:09",
"UpdateTimeStamp" : 1658370789,
"UpdateUserId" : "00000000-0000-0000-0000-000000000000",
"UpdateUserName" : "系统",
"SpecItems" : [ ],
"ResourceItems" : [
{
"ResourceUri" : "https://media.xxx.com/PASSIVES/CAPACITORS/FILM-CAPACITORS/CAPSTICK-CS4-CS6-FILMCAP-SMT-BCK-MED.JPG?m=k9Jv3Y",
"ResourceType" : 1,
"DataSourceType" : "1000",
"SSOGuid" : "00000000-0000-0000-0000-000000000000",
"SSOPathUri" : "",
"DownloadTime" : ""
},
{
"ResourceUri" : "https://xxx.com/wp-content/uploads/2018/07/CS-Capstick.pdf",
"ResourceType" : 3,
"DataSourceType" : "1000",
"SSOGuid" : "00000000-0000-0000-0000-000000000000",
"SSOPathUri" : "",
"DownloadTime" : ""
},
{
"ResourceUri" : "https://media.xxx.com/PASSIVES/CAPACITORS/FILM-CAPACITORS/CAPSTICK-CS4-CS6-FILMCAP-SMT-FNT-MED.JPG?m=k9Jxmj",
"ResourceType" : 1,
"DataSourceType" : "1000",
"SSOGuid" : "00000000-0000-0000-0000-000000000000",
"SSOPathUri" : "",
"DownloadTime" : ""
}
]
}
}
]
}
}
2.查询统计子文档SSOGuid的值为"00000000-0000-0000-0000-000000000000"的数量
get sku_goods/_count
{
"query":{
"nested": {
"path": "ResourceItems",
"query": {
"term": {
"ResourceItems.SSOGuid": {
"value": "00000000-0000-0000-0000-000000000000"
}
}
}
}
}
}
3.查询统计子文档SSOGuid的值不为"00000000-0000-0000-0000-000000000000"的数量
get sku_goods/_count
{
"query":{
"nested": {
"path": "ResourceItems",
"query": {
"bool": {
"must_not": [
{
"term": {
"ResourceItems.SSOGuid": {
"value": "00000000-0000-0000-0000-000000000000"
}
}
}
]
}
}
}
}
}