Query only round number in mongodb

Question

every one.

I would like to know if it's possible in mongodb to query only round number.

I have a collection where my documents have a field: amount and this field is a number.

But I would like to get only documents where fields is a round number.

so I saw there is a $round but this round the number and I want only round number not rounded :P

Does anyone if you can do that with query in mongodb ?

thanks a lot

nimrod serok · Accepted Answer · 2022-09-05 18:28:17Z

2

You can use a tolerance to do something like this:

db.collection.aggregate([
  {$match: {
      $expr: {
        $lte: [
          {$abs: {$subtract: ["$amount", {$round: "$amount"}]}},
          0.000001
        ]
      }
    }
  }
])

See how it works on the playground example

*EDIT: The $round here is a fix by @rickhg12hs to my former $floor. Thanks!

edited Sep 5, 2022 at 18:28

answered Sep 5, 2022 at 14:05

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

3 Comments

nimrod serok Over a year ago

But I use $abs

rickhg12hs Over a year ago

mongoplayground.net/p/bdV-qY6eiTW

nimrod serok Over a year ago

Got you and updated the answer accordingly. Thanks @rickhg12hs

Tom Slabbaert · Accepted Answer · 2022-09-05 14:08:31Z

2

I would use $mod (num % 1) and check that the value is 0, like so:

db.collection.find({
  $expr: {
    $eq: [
      {
        $mod: [
          "$num",
          1
        ]
      },
      0
    ]
  }
})

Mongo Playground

answered Sep 5, 2022 at 14:08

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

Collectives™ on Stack Overflow

Query only round number in mongodb

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related