Selection action in Supbase

Ask us anything How do I?
1

How do I select a specific record from a table in Supabase?
Am I missing something or the select action doesn’t let me specific the fields that I want to search from

Screenshot 2023-11-03 at 3.30.47 PM
Screenshot 2023-11-03 at 3.30.47 PM550×582 22.8 KB

Can anyone help?

2

Hi, you’re not missing anything. We are currently reworking the supabase plugins to implement many improvements, including filters on this action.

In the meantime you can either =>

  • Use a collection with filters as a way to fetch your data instead of an action.
  • Use javascript and make the request yourself using the sdk through wwLib.wwPlugins.supabase.instance
3

Actually, if you’re using RLS, you need to use wwLib.wwPlugins.supabaseAuth.publicInstance, isn’t it Alexis? This one has the authentificated session i think?

4

wwLib.wwPlugins.supabase.instance and wwLib.wwPlugins.supabaseAuth.publicInstance share the same instance

5

I see, then I have no clue why I’m using the auth one, thanks for the clarification anyway)

6

ic. Thanks Alexis!