Paginating two joined tables with range()
I've been stuck on figuring out how to paginate two tables that were joined. Code:
let result = await supabase
.from('Events')
.select(
.eq(
'Market.event',
'FC Barcelona vs Madrid 10/2/22',
).range(0, 9, {foreignTable: 'Market'})
The {foreignTable: 'Market'} makes the above query not run. I'm trying to get 10 entries from the Market table for which 'event' equals 'FC Barcelona vs Madrid 10/2/22'. I would appreciate any help here.
let result = await supabase
.from('Events')
.select(
*, Market!Market_event_fkey!inner (*)).eq(
'Market.event',
'FC Barcelona vs Madrid 10/2/22',
).range(0, 9, {foreignTable: 'Market'})
The {foreignTable: 'Market'} makes the above query not run. I'm trying to get 10 entries from the Market table for which 'event' equals 'FC Barcelona vs Madrid 10/2/22'. I would appreciate any help here.
