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