0

My Goal is to get the coordinates in human readable form without using a seperate request as follows.

supabase.rpc('fn')

I have a table named live_route and it is linked to an other table named profile. I want to get the data of profile and live_route. Table Relations are Profile => Shifts => Locations => Live_route

From below Code You will understand the relations more clearly and how I want to run the function.

   const { data, error } = await supabase
.from('profiles')
.select(`
      id,
      first_name,
      last_name,
      status,
      role,
      profile_image_url,
      phone,
      created_at,
      rating,
      experience,
      user_id,
      email,
      availability,
      last_sign_in_at,
      shifts (
      *,
        location:locations (
          *
        ),
        live_location: live_route(
        coordinates,
        lng_lat: lng_lat_conversion(coordinates)
        )
      ),
      ...organizations(
        organization_name: name
      ), certificates(name)
      `)
.eq('id', id)
.single();

Currently I am getting following error

Relation between Profile and lng_lat_conversion not found.

Please guide how I can achieve my goal of sending a signle request without using rpc.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.