ordering on renaming aggregate rest

let { data, error } = await supabase
.from('transaction_items')
.select(products(*), total:quantity.sum())
.order('total', { ascending: false })

error
{
"code":"42703",
"details":null,
"hint":null,
"message":"column transaction_items.total does not exist"
}
Was this page helpful?