Supabase•4y ago•

5 replies

How to eq() a table that is not a direct join?

I have 3 tables.

battle

battle

teams

teams

and

user

user

. They are linked to each other in this order, but

battle

battle

does not have a direct relation with

user

user

.

I want to query every

user

user

that has at least one battle that is public. For this I have

battle.public IS TRUE

battle.public IS TRUE

.

How do I join

user

user

and

battle

battle

with supabase-js?

Here is a code example of my (failed) attempt:

const { data: users } = await this.$supabase
        .from('user')
        .select('id, name, team:inner(battle:inner(*))')
        .eq('battle.public', 'true')

const { data: users } = await this.$supabase
        .from('user')
        .select('id, name, team:inner(battle:inner(*))')
        .eq('battle.public', 'true')

Does anyone know?

Supabase•4y ago•

5 replies

Relisora

How to eq() a table that is not a direct join?

I have 3 tables.

battle

battle

teams

teams

and

user

user

. They are linked to each other in this order, but

battle

battle

does not have a direct relation with

user

user

.

I want to query every

user

user

that has at least one battle that is public. For this I have

battle.public IS TRUE

battle.public IS TRUE

.

How do I join

user

user

and

battle

battle

with supabase-js?

Here is a code example of my (failed) attempt:

const { data: users } = await this.$supabase
        .from('user')
        .select('id, name, team:inner(battle:inner(*))')
        .eq('battle.public', 'true')

const { data: users } = await this.$supabase
        .from('user')
        .select('id, name, team:inner(battle:inner(*))')
        .eq('battle.public', 'true')

Does anyone know?

How to eq() a table that is not a direct join?

Similar Threads

How to eq() a table that is not a direct join?

Similar Threads

Similar Threads

Similar Threads