query-projections.ais
execute(input)
db = service "database_orders"
filter = {
deleted: false,
"supplier.id": input.supplierId,
"supplier.deleted": false
}
cursor = db.query({
from: "PurchaseOrder (id, reference, total, supplier (id, name))",
where: filter,
orderBy: { timestamp: "desc", id: "asc" },
offset: input.offset,
count: input.pageSize
})
orders = []
for each row in cursor
orders.add(row.data())
end
total = db.count({ from: "PurchaseOrder", where: filter })
return { orders: orders, total: total }
end
All examples