[BUG] supabase dataProvider getList uses invalid "foreignTable" option in .order() #6999
Description
Describe the bug
I was trying to sort by a joined table column and it was not working. A look into postgrest-js docs reveals the issue: order() method's arguments
https://supabase.github.io/postgrest-js/v2/classes/PostgrestTransformBuilder.html#order
sorters?.map((item) => {
const [foreignTable, field] = item.field.split(/\.(?=[^.]+$)/);
if (foreignTable && field) {
query
.select(meta?.select ?? `*, ${foreignTable}(${field})`) // why call select here AGAIN?
.order(field, { // should be `${foreignTable}(${field})'
ascending: item.order === "asc",
foreignTable: foreignTable, // this key does not exist
});
} else {
query.order(item.field, {
ascending: item.order === "asc",
});
}
});Steps To Reproduce
- Create a refine project with ant design and supabase, with examples.
- In blog-posts list, add a column with key=categories.name, dataIndex=["categories","name"] and sorter props.
- Click arrows to sort: nothing happens
Expected behavior
Get table with rows sorted by category name
Packages
- @refinedev/supabase 6.0.0
- @refinedev/antd 6.0.1
- @supabase/supabase-js 2.7.0
Additional Context
How I got it to work
sorters?.map((item) => {
const [foreignTable, field] = item.field.split(/\.(?=[^.]+$)/);
if (foreignTable && field) {
query.order(`${foreignTable}(${field})`, {
ascending: item.order === "asc",
});
} else {
query.order(item.field, {
ascending: item.order === "asc",
});
}
});