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

Search AISDL

Search the paper, references and examples.