Supabase collection - no advanced mode possible?

When setting up a new collection, I want the collection to contain data from two tables. So I was trying to use the advanced mode to join the tables (as explained https://docs.weweb.io/plugins/data-sources/supabase-data.html#advanced-mode) (RLS is right now set up for testing so that every authenticated user could do anything). However, as soon as I click “Advanced” the option disappears and I cannot select “Guided” mode any more (so no selection of columns possible). Why is that? How to fix this?

Before clicking “Advanced”

After clicking “Advanced”

It’s a bug, just re-create the collection. I haven’t found a way to reproduce this, but it’s a bug. It works after a few tries.

Hhm, are you sure? I’m having this problem for quite a long time already with every collection that I try to set up in Advanced mode. I tried it just now 7 times - and it does not change anything. If it’s a bug, there should still be some logic behind and not only work randomly, I guess.

Thanks a lot @Broberto, it’s a very weird issue then!

Hey everyone,

I encounter now the same issue. How to get it solved?

Console error in browser (no extensions running):

index-BwqjUYKk.js:15 TypeError: Cannot read properties of undefined (reading ‘user_profiles’)
at Proxy.isRealtime (manager.js?v=1:1:3294)
at hMe (index-BwqjUYKk.js:11:3260)
at get value (index-BwqjUYKk.js:11:15297)
at Object.get [as isRealtime] (index-BwqjUYKk.js:16:12816)
at Object.get (index-BwqjUYKk.js:16:10272)
at Proxy.isPrimaryRequired (manager.js?v=1:1:3919)
at hMe (index-BwqjUYKk.js:11:3260)
at get value (index-BwqjUYKk.js:11:15297)
at Object.get [as isPrimaryRequired] (index-BwqjUYKk.js:16:12816)
at manager.js?v=1:1:6580

Later edit: seems to be connected to the realtime functionality. If enabled, everything works like in the documentation

Realtime doesn’t work with Advanced (joins)