query-summary.ais
execute(input)
db = service "database_orders"
row = db.first({
from: "PurchaseOrder (id:count, total:sum, total:avg)",
where: { deleted: false, "supplier.id": input.supplierId }
})
data = row.data()
// No contributing values produce null sums/averages, not necessarily zero.
amount = data["total:sum"]
average = data["total:avg"]
if amount == null
amount = 0
end
if average == null
average = 0
end
return { orderCount: data["id:count"], amount: amount, average: average }
end
All examples