How to query on table relation?

[o8e]

I can't see anything in the docs to suggest you can do this, and attempting the obvious ways doesn't seem to give me much joy.

return this.$supabase
  .from('posts')
  .select(`*,meta:posts_tracks(tracks(*))`)
  .gte('???????.tracks.duration', 600000)

I need something like this. I have got it returning the right results in the tracks array, but it still returns all the posts, just with if they don't match:

"meta": [
  {
    "tracks": null
  }
]

Any thoughts? Cheers.

[easy-street]

i believe this is a known issue. from: #875 (comment)

A workaround would be to filter the nulls on client side.

[o8e]

Thank you. That's a shame, filtering on the client means that you can't really paginate properly. I'll keep an eye on that issue then.

[awalias]

yes this is dependent on PostgREST/postgrest#1075