How to do the query to obtain the animal of a sing...
# helpb
Bwaldir
09/16/2021, 6:17 PMHow to do the query to obtain the animal of a single user . Help me
s
silentworks
09/16/2021, 6:25 PMAre you asking about SQL query or using the supabase-js client library?
b
Bwaldir
09/16/2021, 6:37 PMSupabase js
s
silentworks
09/16/2021, 6:38 PM Copy code
js
const { data, error } = await supabase
.from('app_users')
.select(
`
*,
galpon(container(animal(*)))
`
)
.eq('user_id', user_id);b
Bwaldir
09/16/2021, 7:31 PMand if I want only the animals with the same status true
Bwaldir
09/17/2021, 2:36 AMCould not find a relationship between app_user and galpon in the schema cache
Bwaldir
09/17/2021, 2:37 AMhelp me with this error
s
silentworks
09/17/2021, 9:42 AMYour relationship is probably not formed properly
b
Bwaldir
09/17/2021, 2:03 PMfinal response = await client
.from('app_users')
.select(
'*, galpon(container(animal(**)))'
)
.eq('user_id', user.id)
.execute();
Bwaldir
09/17/2021, 2:07 PMIt should return the animals data, but it only returns galpon data, why?
s
silentworks
09/17/2021, 4:41 PMYou currently have two * in your animal brackets which is incorrect, it should only be one *, also if its not working its due to the foreign keys not setup properly
b
Bwaldir
09/17/2021, 6:22 PMright, I just realized
Bwaldir
09/17/2021, 6:24 PMfinal response = await client
.from('app_users')
.select(
'* , galpon( * ,container( *, animal( * )))'
)
.eq('user_id', user.id)
.execute();
Bwaldir
09/17/2021, 6:27 PMthis way it works
Bwaldir
09/17/2021, 6:30 PMI have one last query, how do I make the animals filter only those that state equals true?