refinedev/refine @pankod/refine-supabase@3.27.0

on GitHub

Minor Changes

• Add foreignTable propery to the supabase order statement to access relational data. For more information, you can check the 🔗documentation.

  What we added to the getlist hook is the following:

  💡 How use the foreignTable property?

  ...
  const { tableProps } = useTable({
      resource: "posts",
      initialSorter: [
          {
              field: "categories.title",
              order: "asc",
          },
      ],
  });

  📢 field: "categories.title" means in the posts table categories is the foreign table, title is the field in the foreign table, and asc is the order.

  🚨 If you are using Ant Design don't forget to pass the sorter and dataIndex property to the your Columm component:

  ...
  <Table.Column
      dataIndex={["categories", "title"]}
      title="Categories"
      sorter

  Warning
  We have developed this feature due to an issue here but currently, supabase doesn't support it. You can follow the progress here 👇

  • supabase/supabase#4255
  • supabase/postgrest-js#198