Background Tasks in Xano

// This task runs every day at 11 PM UTC and generates a sales report
task daily_sales_report {
  description = "Generate a daily sales report at 11 PM UTC"
  stack {
    db.query payment_transactions {
      description = "Get all transactions from the past 24 hours"
      where = $db.payment_transactions.transaction_date >= (now|transform_timestamp:"24 hours ago":"UTC")
    } as $daily_sales

    var $transaction_count {
      value = $daily_sales|count
      description = "Count number of transactions"
    }

    var $total_sales {
      value = ($daily_sales[$$].amount)|sum
      description = "Calculate total sales amount"
    }

    db.add reports {
      data = {
        report_type      : "daily_sales"
        report_date      : now
        total_sales      : $total_sales
        transaction_count: $transaction_count
      }
      description = "Insert daily sales report"
    } as $report_result

    debug.log {
      value = "Daily sales report generated"
      description = "Log report generation"
    }
  }
  schedule = [{starts_on: 2025-10-20 13:47:35+0000, freq: 86400}]

}