MongoDb Query Filtering with arithmetic expression

Question

i have a query in sql that I wan't to translate into the MongoDb query.

The statement is:

select * from TBA where a/b < c/d

a,b,c are columns in the table tba and d is a constant

How can I rewrite this statement into the MongoDb query language? I have a document collection called "TBA" where all documents are stored. Now I want to find out which documents fulfill the condition "a/b < c/d".

Thank you in advance.

Best regards, user12682244

nimrod serok · Accepted Answer · 2022-09-23 08:05:32Z

1

If you want to do a calculation using the values stored in the document, you need to use a pipeline:

db.collection.aggregate([
  {$match: {
      $expr: {
        $lt: [
          {$divide: ["$a", "$b"]},
          {$divide: ["$c", d]}
        ]
      }
    }
  }
])

See how it works on the playground example

edited Sep 23, 2022 at 8:05

answered Sep 23, 2022 at 8:03

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

MongoDb Query Filtering with arithmetic expression

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