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

Search AISDL

Search the paper, references and examples.