Does anyone know how to order nested data from a supabase select?

const { data, error } = await supabase
      .from('packs')
      .select(
        `
          *,
          categories(*, category_items(*, item:item_id(*)))
        `
      )
      .order('created_at', { ascending: true })
      .order('created_at', { foreignTable: 'categories' })
      .order('position', { foreignTable: 'category_items', ascending: false })
      .eq('user_id', token.sub);

Essentially I am selecting from the packs table, all of the related categories, category_items and items. I'd like for the nested category_items to be ordered by position, however they're all coming in totally out of order for some reason

I have the same problem. Can anyone post a simple and working example including tables? https://supabase.io/docs/reference/javascript/order does not help me.

Hey @User I think I figured it out. Here's how I modified my original call:

const { data: packsData, error: packsError } = await supabase
      .from('packs')
      .select(
        `
          *,
          categories(*, category_items(*, item:item_id(*)))
        `
      )
      .order('created_at', { ascending: true })
      .order('created_at', { foreignTable: 'categories' })
      .order('position', {
        foreignTable: 'categories.category_items',
        ascending: true,
      })
      .eq('user_id', token.sub);

Hi @User! Here is my problem:

Hey @User , I'm not 100% sure (it's been more trial-and-error for me), but have you tried

.order('last_name', { foreignTable: 'customers' })

?

Thanks @User but it didn't work.