Update with Foreign key
Hi, I have to update a table based on the foreign key. I am using nhost as the data provider.
Dmutate({
resource: "products",
values: {
name: "New Product",
material: "Wood",
},
id: 1,
});
resource: "products",
values: {
name: "New Product",
material: "Wood",
},
id: 1,
});
Dinstead of primary key, i want to change the record based on the foreign key
Erefine's data provider packages uses
Like, to get the primary key you can do a
iduseUpdate or useUpdateMany (depends on your use case) and supplying the idids to change from a useList hook with filters?Like, to get the primary key you can do a
useList and filter by your foreign key. Get the primary key and run the useUpdate with your values and idokay..I will check that. Thank you.
EThought maybe those docs can help
Filtering in
Filtering in
useList https://refine.dev/docs/api-reference/core/hooks/data/useList/#filteringiduseUpdate https://refine.dev/docs/api-reference/core/hooks/data/useUpdate/#id-ELet me know if you have any issues while implementing this 