$setIsSubset (aggregation)

項目一覧

定義
動作
例

定義

$setIsSubset

Takes two arrays and returns true when the first array is a subset of the second, including when the first array equals the second array, and false otherwise.

$setIsSubsetの構文は次のとおりです。

{ $setIsSubset: [ <expression1>, <expression2> ] }

引数は、それぞれが配列に変換される限り、どのような有効な式でも使用できます。式の詳細については、「式演算子」を参照してください。

動作

$setIsSubsetは、配列をセットとして扱い、配列に対してセット演算を実行します。配列に重複エントリが含まれている場合、 $setIsSubsetは重複エントリを無視します。 $setIsSubsetは要素の順序を無視します。

セットにネストされた配列要素が含まれている場合、 $setIsSubsetはネストされた配列に下降せず、最上位の配列を評価します。

例

結果

{ $setIsSubset: [ [ "a", "b", "a" ], [ "b", "a" ] ] }

true

{ $setIsSubset: [ [ "a", "b" ], [ [ "a", "b" ] ] ] }

false

例

以下のドキュメントを持つflowersコレクションを検討してください。

db.flowers.insertMany( [
   { "_id" : 1, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "rose", "orchid" ] },
   { "_id" : 2, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "orchid", "rose", "orchid" ] },
   { "_id" : 3, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "rose", "orchid", "jasmine" ] },
   { "_id" : 4, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "jasmine", "rose" ] },
   { "_id" : 5, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ ] },
   { "_id" : 6, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ [ "rose" ], [ "orchid" ] ] },
   { "_id" : 7, "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ [ "rose", "orchid" ] ] },
   { "_id" : 8, "flowerFieldA" : [ ], "flowerFieldB" : [ ] },
   { "_id" : 9, "flowerFieldA" : [ ], "flowerFieldB" : [ "rose" ] }
] )

The following operation uses the $setIsSubset operator to determine if the flowerFieldA array is a subset of the flowerFieldB array:

db.flowers.aggregate(
   [
     { $project: { flowerFieldA:1, flowerFieldB: 1, AisSubset: { $setIsSubset: [ "$flowerFieldA", "$flowerFieldB" ] }, _id:0 } }
   ]
)

この操作は次の結果を返します。

{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "rose", "orchid" ], "AisSubset" : true }
{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "orchid", "rose", "orchid" ], "AisSubset" : true }
{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "rose", "orchid", "jasmine" ], "AisSubset" : true }
{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ "jasmine", "rose" ], "AisSubset" : false }
{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ ], "AisSubset" : false }
{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ [ "rose" ], [ "orchid" ] ], "AisSubset" : false }
{ "flowerFieldA" : [ "rose", "orchid" ], "flowerFieldB" : [ [ "rose", "orchid" ] ], "AisSubset" : false }
{ "flowerFieldA" : [ ], "flowerFieldB" : [ ], "AisSubset" : true }
{ "flowerFieldA" : [ ], "flowerFieldB" : [ "rose" ], "AisSubset" : true }

戻る

$setIntersection

$setUnion