Is there a way to limit rows from

talents

based on data from

proposals

table in this query? Like I only want rows from

talents

if if a match between

talents.id

and

proposals.talent_id

let { data, error } = await supabase
            .from('jobs')
            .select(`*, proposals(*), talents(*)`)
            .ilike('address', jobAddress)

Hello @Big Bird! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

No. The closest thing is to filter an included table against a known value. https://supabase.com/docs/reference/javascript/select#filtering-with-inner-joins You could do something in an rpc call and a Postgres function.

Thread was archived by @Big Bird. Anyone can send a message to unarchive it.