Find the oldest orders

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

The compiled query

{
  "type": "find",
  "collection": "orders",
  "sort": {
    "placedAt": 1
  },
  "limit": 1
}

How the compiled query works

Sorts by placedAt ascending.
Returns at most 1 documents.

Example results

Live output from running this query against the sample dataset.

totalCents	status	placedAt	customerId	productIds
32900	delivered	2026-07-19T20:08:22.972Z	6a710150fb3d9d8ba951f41e	["6a710150fb3d9d8ba951f421"]

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 the oldest orders

The compiled query

How the compiled query works

Example results

Related queries