Bando Documentation

findMany()

Query documents and receive the results together with the total count.

After creating documents, the next task is retrieving them in your application.

Bando lets you combine filters, pagination, and sorting in a single query.

Imagine we want the 10 most recently published posts:

const { data, total } =

await bando.collection<Post>("posts").findMany({

limit: 10,

offset: 0,

sort: "-createdAt",

filters: {

published: true,

});

The result contains two important pieces of information:

const { data, total } = result;

data contains the documents found.

total contains the total number of documents matching the query, allowing you to build pagination into the interface.

limit defines how many documents we want to receive.offset defines how many documents should be skipped before results start being returned.

For example, to fetch the first 10:

{

limit: 10,

offset: 0,

}

To fetch the next 10:

{

limit: 10,

offset: 10,

}

Sorting accepts id, createdAt, andupdatedAt.

A - before the field means descending order:

sort: "-createdAt"

Current filters use equality.

filters: {

published: true,

}

This searches for documents whose published field is true.

Parâmetro	Tipo	Obrigatório	Por omissão	Descrição
`limit`	integer	não	—	Maximum number of documents returned. Must be a non-negative integer.
`offset`	integer	não	0	Number of documents skipped before results start being returned.
`sort`	string	não	-createdAt	Field used to sort results. Accepts id, createdAt, or updatedAt. The - prefix indicates descending order.
`field`	string	não	—	Equality filter. For example, published=true searches for documents whose published field is true.