ordering on renaming aggregate rest
let { data, error } = await supabase
.from('transaction_items')
.select(
.order('total', { ascending: false })
error
{
"code":"42703",
"details":null,
"hint":null,
"message":"column transaction_items.total does not exist"
}
.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"
}