conscious-sapphire•3mo ago

Supabase- Filter useList by array with the "nin" operator

Hi everyone, I have a useList where I want to filter out a few users with a passed array. If I add a filter using the "in" operator, it returns the results filtered by the users in the array, however supabase throws an error when trying to use the "nin" operator. Is there a solution to filter in such a way?

const { data: reportsData } = useList<IReport, HttpError>({
resource: 'reports',

filters: [
{
field: 'received',
operator: 'eq',
value: 'false',
},
{
field: 'user_full_name',
operator: 'in',
value: ['Testing Tom', 'Testing Bob'],
},
],

pagination: {
mode: 'off',
},
});

const { data: reportsData } = useList<IReport, HttpError>({
resource: 'reports',

filters: [
{
field: 'received',
operator: 'eq',
value: 'false',
},
{
field: 'user_full_name',
operator: 'in',
value: ['Testing Tom', 'Testing Bob'],
},
],

pagination: {
mode: 'off',
},
});

0 Replies

No replies yetBe the first to reply to this messageJoin