frubalu
09/16/2021, 5:39 PMconst { data, error } = await supabase
.from('packs')
.select(
`
*,
categories(*, category_items(*, item:item_id(*)))
`
)
.order('created_at', { ascending: true })
.order('created_at', { foreignTable: 'categories' })
.order('position', { foreignTable: 'category_items', ascending: false })
.eq('user_id', token.sub);
Essentially I am selecting from the packs table, all of the related categories, category_items and items. I'd like for the nested category_items to be ordered by position, however they're all coming in totally out of order for some reasonMattias
09/17/2021, 8:46 AMfrubalu
09/17/2021, 3:16 PMconst { data: packsData, error: packsError } = await supabase
.from('packs')
.select(
`
*,
categories(*, category_items(*, item:item_id(*)))
`
)
.order('created_at', { ascending: true })
.order('created_at', { foreignTable: 'categories' })
.order('position', {
foreignTable: 'categories.category_items',
ascending: true,
})
.eq('user_id', token.sub);
.order
, I'm specifying the foreignTable as categories.category_items
Mattias
09/20/2021, 9:43 AMconst { data } = await supabase
.from('customers_subscriptions')
.select('
id,
customer (first_name, last_name),
subscription (name)')
.order('customer', { foreignTable: 'customers.last_name' });
frubalu
09/20/2021, 3:10 PM.order('last_name', { foreignTable: 'customers' })
?Mattias
09/21/2021, 9:49 AMconst inDeliveryOrder = data.sort(function (a, b) {
return a.customer.delivery_order - b.customer.delivery_order;
});
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/sort