execute(input) db = service "database_orders" cursor = db.query({ from: "PurchaseOrder (timestamp:day, id:count, total:sum)", where: { deleted: false, "supplier.id": input.supplierId, timestamp: { fn: "LastNDays", value: input.days } }, groupBy: ["timestamp:day"], orderBy: { "timestamp:day": "asc" }, offset: 0, count: input.days }) days = [] for each row in cursor data = row.data() days.add({ dayStart: data["timestamp:day"], orderCount: data["id:count"], amount: data["total:sum"] }) end // Missing days are absent, not fabricated zero-valued groups. return { days: days } end