MongoDB -查找任何具有数组组合的文档

Question

蒙古文件如下：

{
    _id: '',
    names: ['ab', 'bc']
}
{
    _id: '',
    names: ['ab', 'de', 'fg']
}
{
    _id: '',
    names: ['bc']
}
{
    _id: '',
    names: ['ab', 'bc', 'cd']
}

我有一个输入数组：

['ab', 'bc', 'cd']

问题：如何获取所有文档，其中的“名称”等于输入数组的任何组合？

结果：以下任何“名称”的所有文档都应该返回

['ab']
['bc']
['cd']
['ab', 'bc']
['bc', 'ab']
['bc', 'cd']
['cd', 'bc']
... and so on..
['ab', 'bc', 'cd']

Answer 1

您可以在find中使用find获取带有名称数组的$size of $setIntersection

db.tt.find({$expr : {$gt : [{$size : {$setIntersection : ["$names", ["ab","bc","cd"]]}}, 0]}})

样本收集

> db.tt.find()
{ "_id" : "1", "names" : [ "ab", "bc" ] }
{ "_id" : "2", "names" : [ "ab", "de", "fg" ] }
{ "_id" : "3", "names" : [ "bc" ] }
{ "_id" : "4", "names" : [ "ab", "bc", "cd" ] }

使用$expr和$setIntersection

> db.tt.find({$expr : {$gt : [{$size : {$setIntersection : ["$names", ["ab","bc","cd"]]}}, 0]}})
{ "_id" : "1", "names" : [ "ab", "bc" ] }
{ "_id" : "2", "names" : [ "ab", "de", "fg" ] }
{ "_id" : "3", "names" : [ "bc" ] }
{ "_id" : "4", "names" : [ "ab", "bc", "cd" ] }

与$in (如安东尼的评论中所示)

> db.tt.find({names : {$in : ["ab","bc","cd"]}})
{ "_id" : "1", "names" : [ "ab", "bc" ] }
{ "_id" : "2", "names" : [ "ab", "de", "fg" ] }
{ "_id" : "3", "names" : [ "bc" ] }
{ "_id" : "4", "names" : [ "ab", "bc", "cd" ] }