Merge docs fields who has same phone number

Working with Data
,
1

i want to merge some fields who has same number and number i want to match last 9 digits and and i want validations = separate docs which has invalid address of ‘default_address.phone’ or has null or undefined and after group i want also this docs and grouped dos code provided

result = await Customer.aggregate([
      { $match: { storeId: { $in: stores } } },
      {
        $project: {
          ...selectedFields,
          customerName: { $concat: ["$first_name", " ", "$last_name"] },
        },
      },
      {
        $facet: {
          groupedDocs: [
            {
              $match: {
                "default_address.phone": { $exists: true, $ne: "" },
              },
            },
            {
              $match: {
                $expr: {
                  $gte: [
                    { $strLenCP: { $ifNull: ["$default_address.phone", ""] } },
                    9,
                  ],
                },
              },
            },
            {
              $sort: { _id: 1 },
            },
            {
              $group: {
                _id: {
                  $substrCP: [
                    "$default_address.phone",
                    { $subtract: [{ $strLenCP: "$default_address.phone" }, 9] },
                    9,
                  ],
                },
                orders_count: { $sum: "$orders_count" },
                total_spent: { $sum: { $toDouble: "$total_spent" } },
                last_order_name: { $last: "$last_order_name" },
                last_order_id: { $last: "$last_order_id" },
                ...groupProjection,
              },
            },
            {
              $set: {
                _id: "$docId",
              },
            },
            {
              $unset: "docId",
            },
          ],
          filteredDocs: [
            // {
            //   $match: {
            //     "default_address.phone": { $exists: false, $eq: "" },
            //   },
            // },
            {
              $match: {
                $expr: {
                  $lt: [
                    { $strLenCP: { $ifNull: ["$default_address.phone", ""] } },
                    9,
                  ],
                },
              },
            },
          ],
        },
      },
      {
        $project: {
          docs: { $concatArrays: ["$filteredDocs", "$groupedDocs"] },
        },
      },
      { $unwind: "$docs" },
      { $replaceRoot: { newRoot: "$docs" } },

      { $match: filter },
      {
        $unset: "customerName",
      },
      {
        $sort: { _id: -1 },
      },
      {
        $facet: {
          data: [{ $skip: startIndex }, { $limit: limit }],
          count: [{ $count: "total" }],
        },
      },
    ])``
3

Hi :wave: @Rajpoot_Safee,

Welcome to the MongoDB Community forum :sparkles:

Which fields do you want to merge fields after matching the last 9 digits of a phone number? Can you please elaborate on it further to help us understand the conditions?

Also, it would be helpful if you could help us with further information:

  1. A sample document from the collection.
  2. The expected output from the documents.
  3. The MongoDB version you are on.

Regards,
Kushagra

4

orders_count, total_spent($sum)
last_order_name, last_order_id (replace by last)
all others fields (keep first)
also want get docs without changing data and grouping that have null or “” or less than 9 digits default_address.phone
grouping docs must sorted by older create first before grouping

output = {data: , count: Number}
collection = Customer
“mongodb”: “^4.9.0”,
“mongoose”: “^5.12.15”,

5

Hello :wave: @Rajpoot_Safee,

Apologies for the late response.

Based on the shared information, it’s difficult to comprehend the document structure. Please share the MongoDB sample document from your collection if the issue still persists with the desired output.

Can you please elaborate on what you mean by the above line?

Best,
Kushagra