MongoDB汇总重复

Question

是否可以使用Mongo聚合框架在不同对象键中查找对象值重复的选项？更明确的是，我显示了我的查询以及一些输入和预期的输出：

我的聚合查询：

const Customer = require('../models/Customer');

const getDataDuplicates = (req, res) => {
  Customer.aggregate([
    {
      $group: {
        _id: {
          title:  "$title" ,
          salutation: "$salutation",
          firstName: "$firstName",
          lastName: "$lastName",
          companyName: "$companyName",
          business: "$business",
          street: "$street",
          city: "$city",
          postcode: "$postcode",
          email: "$email",
          phone: "$phone"
        },
        uniqueIds: {$addToSet: "$_id"},
        count: {$sum: 1}
      }
    },
    {
      $match: {
        count: {$gt: 1}
      }
    },
    {
      $sort: {"count": -1}
    },
    {
      $project: {
        "_id": "$uniqueIds",
        "title": "$_id.title",
        "salutation": "$_id.salutation",
        "firstName": "$_id.firstName",
        "lastName": "$_id.lastName",
        "companyName": "$_id.companyName",
        "business": "$_id.business",
        "street": "$_id.street",
        "city": "$_id.city",
        "postcode": "$_id.postcode",
        "email": "$_id.email",
        "phone": "$_id.phone"
      },
    },
  ])

    .then((data) => {
      res.send(data);
    }).catch((e) => {
    res.send(e)
  })
}
module.exports = {getDataDuplicates};

现在，当所有对象数据都相同时，我的查询只有一种情况。但是如果：

1. 两个客户将具有相同的名称，LastName，CompanyName和Email，但其他人将具有相同的电子邮件，街道和电话等。
   

在这里汇总之前的示例数据输入：

    {
        "_id": "6259715edaa388eb639b2ce5",
        "title": "Prof",
        "salutation": "Herr",
        "firstName": "Bartlomiej",
        "lastName": "Slapinski",
        "companyName": "ITSD",
        "business": false,
        "street": "sadasd",
        "city": "Krefeld",
        "postcode": "47805",
        "email": "[email protected]",
        "phone": "2132142143214214",
        "__v": 0
    },
    {
        "_id": "246e9e89c29750f52974566b",
        "title": "Dr",
        "salutation": "Firma",
        "firstName": "Bartlomiej", // duplicate
        "lastName": "Slapinski", // duplicate
        "companyName": "ITSD", // duplicate
        "business": true,
        "street": "Gigstr. 24", 
        "city": "Egal", 
        "postcode": "47225", 
        "email": "[email protected]", //duplicate
        "phone": "2132142143",
        "__v": 0
    },

上面的输入显示名称，姓氏，公司名称和电子邮件是相同的，因此查询结果应该看起来像这样：

    {
        "_id": [
            "6259715edaa388eb639b2ce5",
            "246e9e89c29750f52974566b"
        ],
        "firstName": "Bartlomiej",
        "lastName": "Slapinski",
        "companyName": "ITSD",
        "email": "[email protected]",
    },

因此逻辑应该看起来像这样：

Loop through $group and check if $email is same $or firstName $or and so on and so on ...

如果有什么尚不清楚的话，请提出问题，让我知道我会发布更多信息，谢谢！