查詢數(shù)組大小大于1的文檔我有一個MongoDB集合，其文檔格式如下：{
"_id" : ObjectId("4e8ae86d08101908e1000001"),
"name" : ["Name"],
"zipcode" : ["2223"]}{
"_id" : ObjectId("4e8ae86d08101908e1000002"),
"name" : ["Another ", "Name"],
"zipcode" : ["2224"]}我目前可以獲得與特定數(shù)組大小匹配的文檔：db.accommodations.find({ name : { $size : 2 }})將正確地返回帶有兩個元素的文檔。name陣列。但是，我不能$gt命令返回name字段的數(shù)組大小大于2：db.accommodations.find({ name : { $size: { $gt : 1 } }})如何使用name大小大于一個的數(shù)組(最好不必修改當(dāng)前的數(shù)據(jù)結(jié)構(gòu))？
3 回答
郎朗坤
TA貢獻(xiàn)1921條經(jīng)驗(yàn) 獲得超9個贊
// Find all docs that have at least a second name array element.db.accommodations.find({'name.1': {$exists: true}})db.accommodations.createIndex(
{'name.1': 1},
{partialFilterExpression: {'name.1': {$exists: true}}});
慕田峪7331174
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超13個贊
$where
{$nor: [
{name: {$exists: false}},
{name: {$size: 0}},
{name: {$size: 1}}]}> db.test.save({})
> db.test.save({name: []})
> db.test.save({name: ['George']})
> db.test.save({name: ['George', 'Raymond']})
> db.test.save({name: ['George', 'Raymond', 'Richard']})
> db.test.save({name: ['George', 'Raymond', 'Richard', 'Martin']})
> db.test.find({$nor: [{name: {$exists: false}}, {name: {$size: 0}}, {name: {$size: 1}}]})
{ "_id" : ObjectId("511907e3fb13145a3d2e225b"), "name" : [ "George", "Raymond" ] }
{ "_id" : ObjectId("511907e3fb13145a3d2e225c"), "name" : [ "George", "Raymond", "Richard" ] }
{ "_id" : ObjectId("511907e3fb13145a3d2e225d"), "name" : [ "George", "Raymond", "Richard", "Martin" ] }
>
- 3 回答
- 0 關(guān)注
- 961 瀏覽
添加回答
舉報(bào)
0/150
提交
取消