Hello, I'm finishing this recipe app where a recipe can be created (table user_recipe) and granted to somebody else. This leads to a ListView with a Supabase query from the user_recipe table filtered by 'created by' (uuid) = UserID. This way everyone can only see their recipes, but only their own.
I then have an intermediary table recipe_granted with fields 'recipe_id' and 'user_id', both foreign keys (recipe_granted.recipe_id -> user_recipe.recipe_id; recipe_granted.user_id -> auth.id). How do I set the ListView to filter both the recipe one has created and the recipe someone has been given access to? RLS policies have already been set accordingly in both tables.
I hope my explanation was clear, thank you very much.