Querying

// Exact match
where: {
	status: "published";
}

// Boolean
where: {
	isActive: true;
}

// Relation by ID
where: {
	barber: "barber-id-123";
}

// Greater than / less than
where: { price: { gt: 1000 } }
where: { price: { gte: 1000, lt: 5000 } }

// Date ranges
where: {
  scheduledAt: {
    gte: new Date("2025-03-01"),
    lte: new Date("2025-03-31"),
  },
}

where: {
	title: {
		contains: "hello";
	}
}
where: {
	email: {
		startsWith: "john";
	}
}
where: {
	slug: {
		endsWith: "-draft";
	}
}

where: { status: { in: ["draft", "published"] } }
where: { id: { in: ["id1", "id2", "id3"] } }

orderBy: {
	createdAt: "desc";
}
orderBy: {
	name: "asc";
}
orderBy: {
	price: "asc";
}

const page1 = await client.collections.posts.find({
	limit: 10,
	offset: 0,
});
// page1.docs — first 10 records
// page1.totalDocs — total count

const page2 = await client.collections.posts.find({
	limit: 10,
	offset: 10,
});

const barber = await client.collections.barbers.findOne({
	where: { id: "abc" },
	with: {
		services: true,
		// Nested
		appointments: {
			with: {
				service: true,
			},
		},
	},
});

const posts = await client.collections.posts.find({
	select: { id: true, title: true, status: true },
});
// Only id, title, status returned

handler: async ({ collections }) => {
	const active = await collections.barbers.find({
		where: { isActive: true },
		orderBy: { name: "asc" },
		with: { services: true },
	});
	return active;
};