Many-to-many joiner table permission question

1

I have the following 3 tables:

users = {id, name}
listings = {id, address}
users_to_listings = {id, user, listing, role}

When executing a query against listingsList, users should only be able to see listings for which they are attached to through users_to_listings table. I’ve created a custom role that all users will have. On that role, in the listings object, what read filter do I use for this?

On the listings table, I have tried many things, including:

{
  "users_to_listings": {
    "some": {
      "user": {
        "id": {
          "equals": "__loggedInUserId"
        }
      }
    }
  }
}

Screen Shot 2023-01-26 at 12.38.08 AM
Screen Shot 2023-01-26 at 12.38.08 AM983×749 29.4 KB

2

@kevinwasie is users the User table provided by 8base or a custom table you created?

3

Yes, @estebanf the user table is provided by 8base.

4

@kevinwasie Please take a look at this video. Let me know if it helps

2 Likes
5

:fire: Yes, that is exactly what I needed and I learned how to set the filters now from your video. Thank you VERY much @estebanf.

4 Likes