Supabase: filtering at collection level >> no update after filter is changed?

Ask us anything
1

I have a “goals” collection fetching from supabase with a filter

It filters based on the user active project. If the user has no active project, it doesn`t fetch anything. When the user selects a project, though, I can only see the goals (where goal.project_id = thisuser.project_id) when I refresh the page…

I am fetching users-info and goals collections when the user selects the project and when loading any page that uses the goals colletction, still, I only see the goals after the project is changed when I refresh the page…

Why is this happening?

2

Where are you running the Fetch Collection from? Do you have it in a workflow attached to the Select or whatever you’re using to choose the project? If not already, make sure the Fetch Collection is being run in the workflow after updates to the filters are run.

3

yeah, that`s what I do: when I update the project I fecth user data, projects, goals, etc… everything that is relevant

4

Can you post some screenshots? Specifically of the workflows where your fetch collections are being called from, etc. Will help tremendiously with trouble shooting.