Find in-stock products under $30

MongoDB query compiled from plain English against the ecommerce sample schema, then verified by running it.

The compiled query

{
  "type": "find",
  "collection": "products",
  "filter": {
    "inStock": true,
    "priceCents": {}
  },
  "skip": 0,
  "limit": 0
}

How the compiled query works

Filters products on inStock, priceCents.

Things worth knowing

priceCents stores money as an integer number of cents, so 3000 here means $30.00. Comparing against 30 instead is a common off-by-100 bug.

Write this in plain English instead. Mask Databases compiles the sentence above into exactly this query at build time — no AI at runtime, and you can read the output in a diff.

Try it in the playground → No signup, runs in your browser.

Find in-stock products under $30

The compiled query

How the compiled query works

Things worth knowing

Related queries