How to convert string value to an integer in MongoDB aggregation pipeline

Question

In my NodeJs application I am using MongoDB database. I have two collections products and market_companies. Both collections have a field name hub_id and dimensions, and here dimensions is an object field.

I have created the aggregation pipeline where in both the collections I am comparing hub_id and dimensions field but the thing is hub_id in products collection is an integer but in market_companies it's an string due to which I am not getting desired output.

I want to know how can I convert hub_id to integer from string in market_companies collection.

Below is my code:

     db.products.aggregate([
    {
    $lookup: {
      from: "market_companies",
      let: {
        hubId: "$hubId",
        dimensions: "$dimensions"
      },
      as: "companies",
      pipeline: [
        {
          $match: {
            $expr: {
              $and: [
                {
                  $eq: [
                    "$hubId", // How to convert this into Integer
                    "$$hubId"
                  ]
                },
                {
                  $setEquals: [
                    {
                      "$objectToArray": {
                        $ifNull: [
                          "$dimensions",
                          {}
                        ]
                      }
                    },
                    {
                      "$objectToArray": {
                        $ifNull: [
                          "$$dimensions",
                          {}
                        ]
                       }
                     }
                   ]
                 }
               ]
             }
           }
         },
       ]
      }
     }
    ])

Hi, please try to edit your question to include more details, such as the language you are using. — S. C.
– S. C., Commented Dec 31, 2022 at 14:14

NeNaD · Accepted Answer · 2022-12-31 14:24:01Z

1

You can do it with $toInt operator:

{
  $eq: [
    { $toInt: "$hubId" },
    "$$hubId"
  ]
},

answered Dec 31, 2022 at 14:24

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert string value to an integer in MongoDB aggregation pipeline

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related