Supabase filter by

[albertcito]

The documentation displays filter by could be customized changing a global variable.

Why this library doesn't allow just call it in this way?:

const author = '12345';
messages$.filter((from) => from.eq('author', author )).get()

But now I have to modify the global variable 👎 , in order to be able to change the filter. It hide what the .get() function is getting and I have to reset each global variable in order to use it again :/

author = '12345';
messages$.get()

[jmeistrich]

Oh that documentation is not meant to suggest a global variable. I'll look at clarifying and expanding on that in the docs.

For this case you probably want to use a lookup table to create a different synced observable for each author.

const messages$ = observable((authorId: string) => syncedSupabase({
    supabase,
    collection: 'messages',
    // Filter by the current user
    filter: (select) => select.eq('user_id', authorId)
}))

const messages12345$ = messages$['12345']
const messages12345 = messages$['12345'].get();

This way you can treat messages$ as an observable object where each child is an author, and it will start syncing an author as soon as you get() it.

[albertcito]

What if I need to add more filters like?

• select.in('user_id', authorIds)
• select.in('user_id', authorIds).eq('status', status)

[jmeistrich]

You could also have the select function get() other observables, and it will re-run whenever those change. So if you want messages$ to update whenever you change authorIds or status you could do something like this:

const authorIds$ = observable(['12345'])
const status$ = observable('read')
const messages$ = observable(syncedSupabase({
    supabase,
    collection: 'messages',
    // Filter by the current user
    filter: (select) => select.in('user_id', authorIds$.get()).eq('status', status$.get())
}))

observe(() => {
    console.log(messages$.get())
})

status$.set('unread')