supabase-js query with nested date compare

I'm trying to use a filter inside a join query for products but am getting errors. Here is the query:

const { data, error } = await locals.supabase
    .from('trucks')
    .select('id, products(*, arrival_time.gte.now()), routes(*).order(order)')
    .eq('id', params.truckId)
    .single()

const { data, error } = await locals.supabase
    .from('trucks')
    .select('id, products(*, arrival_time.gte.now()), routes(*).order(order)')
    .eq('id', params.truckId)
    .single()

const { data, error } = await locals.supabase
    .from('trucks')
    .select('id, products(*, arrival_time.gte.now()), routes(*).order(order)')
    .eq('id', params.truckId)
    .single()

const { data, error } = await locals.supabase
    .from('trucks')
    .select('id, products(*, arrival_time.gte.now()), routes(*).order(order)')
    .eq('id', params.truckId)
    .single()

which give me the error

unexpected '.'

unexpected '.'

unexpected '.'

unexpected '.'

so I asked the supabase AI and it gave me another way:

'id, products(* , arrival_time >= now()), routes(*).order(order)'

'id, products(* , arrival_time >= now()), routes(*).order(order)'

'id, products(* , arrival_time >= now()), routes(*).order(order)'

'id, products(* , arrival_time >= now()), routes(*).order(order)'

which also gave me an error

unexpected '>'

unexpected '>'

unexpected '>'

unexpected '>'

Is there a way to do this type of query with the supabase-js client? Looks like I'm on

^2.45.0

^2.45.0

^2.45.0

^2.45.0.

supabase-js query with nested date compare

Similar Threads

Similar Threads

Similar Threads