query-projections.ais

execute(input)
  db = service "database_orders"
  filter = {
    deleted: false,
    "supplier.id": input.supplierId,
    "supplier.deleted": false
  }
  cursor = db.query({
    from: "PurchaseOrder (id, reference, total, supplier (id, name))",
    where: filter,
    orderBy: { timestamp: "desc", id: "asc" },
    offset: input.offset,
    count: input.pageSize
  })
  orders = []
  for each row in cursor
    orders.add(row.data())
  end
  total = db.count({ from: "PurchaseOrder", where: filter })
  return { orders: orders, total: total }
end
All examples

Search AISDL

Search the paper, references and examples.