query-daily-totals.ais
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
All examples