Mongodb過濾器filter選擇要返回的數(shù)組子集操作方法
更新時間：2023年07月19日 14:36:18 作者：Ethanchen's?notes
Mongodb使用過濾器 $filter根據(jù)指定條件選擇要返回的數(shù)組子集，這篇文章主要介紹了Mongodb對嵌套文檔數(shù)組進行查詢操作,需要的朋友可以參考下
Mongodb過濾器
Mongodb使用過濾器 $filter 根據(jù)指定條件選擇要返回的數(shù)組子集。返回僅包含與條件匹配的元素的數(shù)組。返回的元素按原始順序排列。也就是說，這個是選擇你要的文檔，而不是排除。 如果該數(shù)組沒有符合條件 ，則為 空 []
$filter: 選擇數(shù)組的子集以返回僅包含與過濾條件匹配的元素的數(shù)組。
插入測試數(shù)據(jù)
sit_rs1:PRIMARY> db.user.insertMany([
... { name: "user1", age: 10, letter: [{"x":"X1", "y":"Y1"}, {"x":"X2", "y":"Y2"}, {"x":"X3", "y":"Y3"}], number: [ { "n1":2, "n2":6 }, { "n1":3, "n2":3 }, { "n1":5, "n2":6 } ] },
... { name: "user2", age: 20, letter: [{"V":"V1", "y":"Y1"}, {"V":"V2", "y":"Y2"}, {"V":"V3", "y":"Y3"}], number: [ { "n1":1, "n2":3 }, { "n1":4, "n2":5 }, { "n1":7, "n2":6 } ] },
... { name: "user3", age: 30, letter: [{"V":"V1", "w":"W1"}, {"V":"V2", "w":"W2"}, {"V":"V3", "w":"W3"}], number: [ { "n1":1, "n2":8 }, { "n1":2, "n2":6 }, { "n1":2, "n2":6 } ] },
... { name: "user4", age: 45, letter: [{"z":"Z1", "w":"W1"}, {"z":"Z2", "w":"W2"}, {"z":"Z3", "w":"W3"}], number: [ { "n1":9, "n2":8 }, { "n1":2, "n2":4 }, { "n1":3, "n2":6 } ] },
... { name: "user5", age: 55, letter: [{"z":"Z1", "u":"U1"}, {"z":"Z2", "u":"U2"}, {"z":"Z3", "u":"U3"}], number: [ { "n1":7, "n2":8 }, { "n1":8, "n2":4 }, { "n1":4, "n2":6 } ] },
... { name: "user6", age: 55, letter: [{"t":"T1", "u":"U1"}, {"t":"T2", "u":"U2"}, {"t":"T3", "u":"U3"}], number: [ { "n1":5, "n2":8 }, { "n1":8, "n2":5 }, { "n1":7, "n2":6 } ] },
... ])
{
"acknowledged" : true,
"insertedIds" : [
ObjectId("64b661869be837dc8e997b74"),
ObjectId("64b661869be837dc8e997b75"),
ObjectId("64b661869be837dc8e997b76"),
ObjectId("64b661869be837dc8e997b77"),
ObjectId("64b661869be837dc8e997b78"),
ObjectId("64b661869be837dc8e997b79")
]
}
sit_rs1:PRIMARY> db.user.find()
{ "_id" : ObjectId("64b661869be837dc8e997b74"), "name" : "user1", "age" : 10, "letter" : [ { "x" : "X1", "y" : "Y1" }, { "x" : "X2", "y" : "Y2" }, { "x" : "X3", "y" : "Y3" } ], "number" : [ { "n1" : 2, "n2" : 6 }, { "n1" : 3, "n2" : 3 }, { "n1" : 5, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b75"), "name" : "user2", "age" : 20, "letter" : [ { "V" : "V1", "y" : "Y1" }, { "V" : "V2", "y" : "Y2" }, { "V" : "V3", "y" : "Y3" } ], "number" : [ { "n1" : 1, "n2" : 3 }, { "n1" : 4, "n2" : 5 }, { "n1" : 7, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b76"), "name" : "user3", "age" : 30, "letter" : [ { "V" : "V1", "w" : "W1" }, { "V" : "V2", "w" : "W2" }, { "V" : "V3", "w" : "W3" } ], "number" : [ { "n1" : 1, "n2" : 8 }, { "n1" : 2, "n2" : 6 }, { "n1" : 2, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b77"), "name" : "user4", "age" : 45, "letter" : [ { "z" : "Z1", "w" : "W1" }, { "z" : "Z2", "w" : "W2" }, { "z" : "Z3", "w" : "W3" } ], "number" : [ { "n1" : 9, "n2" : 8 }, { "n1" : 2, "n2" : 4 }, { "n1" : 3, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b78"), "name" : "user5", "age" : 55, "letter" : [ { "z" : "Z1", "u" : "U1" }, { "z" : "Z2", "u" : "U2" }, { "z" : "Z3", "u" : "U3" } ], "number" : [ { "n1" : 7, "n2" : 8 }, { "n1" : 8, "n2" : 4 }, { "n1" : 4, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b79"), "name" : "user6", "age" : 55, "letter" : [ { "t" : "T1", "u" : "U1" }, { "t" : "T2", "u" : "U2" }, { "t" : "T3", "u" : "U3" } ], "number" : [ { "n1" : 5, "n2" : 8 }, { "n1" : 8, "n2" : 5 }, { "n1" : 7, "n2" : 6 } ] }$filter 具有以下語法：
{ $filter: { input: <array>, as: <string>, cond: <expression> } }- input: 解析為數(shù)組的表達式。
- as: 可選的。代表數(shù)組中每個單獨元素的變量名稱input。如果未指定名稱，則變量名稱默認為this。
- cond: 解析為布爾值的表達式，用于確定是否應將某個元素包含在輸出數(shù)組中。表達式使用as中指定的變量名分別引用輸入數(shù)組的每個元素。
# 以下示例選擇 number 數(shù)組 n1 字段 僅包含 “大于5” 的文檔：
sit_rs1:PRIMARY> db.user.aggregate([
... {
... $project: {
... number: {
... $filter: {
... input: "$number",
... as: "number",
... cond: { $gt: [ "$$number.n1", 5 ] }
... }
... }
... }
... }
... ])
{ "_id" : ObjectId("64b661869be837dc8e997b74"), "number" : [ ] }
{ "_id" : ObjectId("64b661869be837dc8e997b75"), "number" : [ { "n1" : 7, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b76"), "number" : [ ] }
{ "_id" : ObjectId("64b661869be837dc8e997b77"), "number" : [ { "n1" : 9, "n2" : 8 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b78"), "number" : [ { "n1" : 7, "n2" : 8 }, { "n1" : 8, "n2" : 4 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b79"), "number" : [ { "n1" : 8, "n2" : 5 }, { "n1" : 7, "n2" : 6 } ] }as: 是可選的。如果未指定名稱，則變量名稱默認為this。下面使用 this 代替。
sit_rs1:PRIMARY> db.user.aggregate([
... {
... $project: {
... number: {
... $filter: {
... input: "$number",
... cond: { $gt: [ "$$this.n1", 5 ] }
... }
... }
... }
... }
... ])
{ "_id" : ObjectId("64b661869be837dc8e997b74"), "number" : [ ] }
{ "_id" : ObjectId("64b661869be837dc8e997b75"), "number" : [ { "n1" : 7, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b76"), "number" : [ ] }
{ "_id" : ObjectId("64b661869be837dc8e997b77"), "number" : [ { "n1" : 9, "n2" : 8 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b78"), "number" : [ { "n1" : 7, "n2" : 8 }, { "n1" : 8, "n2" : 4 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b79"), "number" : [ { "n1" : 8, "n2" : 5 }, { "n1" : 7, "n2" : 6 } ] }聚合管道更新
從 MongoDB 4.2 開始，您可以使用聚合管道進行更新：使用聚合管道可以實現(xiàn)更具表現(xiàn)力的更新語句，例如基于當前字段值表達條件更新或使用另一個字段的值更新一個字段。
以下示例，使用 filter 選擇數(shù)組的子集, 再更新原來的數(shù)組。
# 以下示例選擇 number 數(shù)組 n1 字段 僅包含 “大于5” 的文檔：并更新替換原來的數(shù)組
sit_rs1:PRIMARY> db.user.updateMany(
... { "number": { $exists: true } },
... [{
... $set: {
... "number": {
... $filter: {
... input: "$number",
... as: "number",
... cond: { $gt: [ "$$number.n1", 5 ] }
... }
... }
... }
... }]
... )
{ "acknowledged" : true, "matchedCount" : 6, "modifiedCount" : 6 }
sit_rs1:PRIMARY> db.user.find()
{ "_id" : ObjectId("64b661869be837dc8e997b74"), "name" : "user1", "age" : 10, "letter" : [ { "x" : "X1", "y" : "Y1" }, { "x" : "X2", "y" : "Y2" }, { "x" : "X3", "y" : "Y3" } ], "number" : [ ] }
{ "_id" : ObjectId("64b661869be837dc8e997b75"), "name" : "user2", "age" : 20, "letter" : [ { "V" : "V1", "y" : "Y1" }, { "V" : "V2", "y" : "Y2" }, { "V" : "V3", "y" : "Y3" } ], "number" : [ { "n1" : 7, "n2" : 6 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b76"), "name" : "user3", "age" : 30, "letter" : [ { "V" : "V1", "w" : "W1" }, { "V" : "V2", "w" : "W2" }, { "V" : "V3", "w" : "W3" } ], "number" : [ ] }
{ "_id" : ObjectId("64b661869be837dc8e997b77"), "name" : "user4", "age" : 45, "letter" : [ { "z" : "Z1", "w" : "W1" }, { "z" : "Z2", "w" : "W2" }, { "z" : "Z3", "w" : "W3" } ], "number" : [ { "n1" : 9, "n2" : 8 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b78"), "name" : "user5", "age" : 55, "letter" : [ { "z" : "Z1", "u" : "U1" }, { "z" : "Z2", "u" : "U2" }, { "z" : "Z3", "u" : "U3" } ], "number" : [ { "n1" : 7, "n2" : 8 }, { "n1" : 8, "n2" : 4 } ] }
{ "_id" : ObjectId("64b661869be837dc8e997b79"), "name" : "user6", "age" : 55, "letter" : [ { "t" : "T1", "u" : "U1" }, { "t" : "T2", "u" : "U2" }, { "t" : "T3", "u" : "U3" } ], "number" : [ { "n1" : 8, "n2" : 5 }, { "n1" : 7, "n2" : 6 } ] }到此這篇關于Mongodb過濾器filter選擇要返回的數(shù)組子集的文章就介紹到這了,更多相關Mongodb數(shù)組子集內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持腳本之家！
相關文章
MongoDB 數(shù)據(jù)庫的命名、設計規(guī)范詳解
隨著MongoDB的普及和使用量的快速增長，為了規(guī)范使用，便于管理和獲取更高的性能，整理此文檔2020-02-02
mongodb數(shù)據(jù)庫入門之CURD簡單操作示例
這篇文章主要介紹了mongodb數(shù)據(jù)庫入門之CURD簡單操作,結(jié)合簡單示例形式分析了MongoDB數(shù)據(jù)庫基本的CURD增刪改查相關操作技巧與注意事項,需要的朋友可以參考下2019-10-10
本文收錄了MongoDB的安裝及配置文件選項全解,介紹了MongoDB安裝的方法以及環(huán)境下的一些重要文件,還有最重要的是詳細地羅列了配置文件中的選項含義和參數(shù),需要的朋友可以參考下2016-07-07
最近小編遇到這樣的問題：對集合執(zhí)行一個大排序操作（如聚合），出現(xiàn)以下錯誤：（測試版本：MongoDB 3.0.6），怎么快速解決此問題呢？下面小編給大家分享MongoDB 排序超過內(nèi)存限制的解決方法，一起看看吧2017-07-07
mongodb的用戶信息是存放在system.users表中的，修改密碼不能直接更新表數(shù)據(jù)，這樣的話，存到表里的密碼是明文的，這就不對了。2014-07-07
與關系型數(shù)據(jù)庫相比,MongoDB支持數(shù)組,將數(shù)組存儲到文檔之中,下面這篇文章主要給大家介紹了關于MongoDB對數(shù)組進行增刪改查操作的相關資料,文中通過實例代碼介紹的非常詳細,需要的朋友可以參考下2023-05-05
本文給大家介紹的教程主要參考資源的官方文檔，當然如果你是centos6的，也可以看看其他文章，筆者用的是7，mongodb想用3以上的版本，需要的小伙伴可以參考下2016-11-11
MongoDB數(shù)據(jù)庫常用28條查詢語句總結(jié)
我們經(jīng)常使用的MySQL是最流行的關系型數(shù)據(jù)庫管理系統(tǒng),隨著時代的進步,互聯(lián)網(wǎng)的發(fā)展關系型數(shù)據(jù)庫已經(jīng)不滿足于互聯(lián)網(wǎng)的需求,因此出現(xiàn)了非關系數(shù)據(jù)庫,下面這篇文章主要給大家總結(jié)介紹了關于MongoDB數(shù)據(jù)庫常用28條查詢語句,需要的朋友可以參考下2023-05-05
這篇文章主要介紹了mongodb分片技術，小編覺得挺不錯的，現(xiàn)在分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2017-08-08
這篇文章主要介紹了MongoDB入門教程之聚合和游標操作介紹,聚合和游標可以說是MongoDB中的高級操作了,需要的朋友可以參考下2014-08-08