filtering on not selected column on aggregate solution
let { data, error } = await supabase
.from('transaction_items')
.select(
.gte("transactions.created_at", fromDate)
.lte("transactions.created_at", toDate)
I want to do this, but error
{
"code":"PGRST108",
"details":null,
"hint":"Verify that 'transactions' is included in the 'select' query parameter.",
"message":"'transactions' is not an embedded resource in this request"
}
.from('transaction_items')
.select(
products(*), total:quantity.sum()).gte("transactions.created_at", fromDate)
.lte("transactions.created_at", toDate)
I want to do this, but error
{
"code":"PGRST108",
"details":null,
"hint":"Verify that 'transactions' is included in the 'select' query parameter.",
"message":"'transactions' is not an embedded resource in this request"
}
