© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•8mo ago•
1 reply
Fadlillah

ordering on renaming aggregate rest

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

error
{
"code":"42703",
"details":null,
"hint":null,
"message":"column transaction_items.total does not exist"
}
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

GraphQL Aggregate
SupabaseSSupabase / help-and-questions
6mo ago
filtering on not selected column on aggregate solution
SupabaseSSupabase / help-and-questions
8mo ago
How to enable aggregate functions on self hosted supabase.
SupabaseSSupabase / help-and-questions
8mo ago
Ordering with timestamp not working ;(
SupabaseSSupabase / help-and-questions
4y ago