I have a many_to_many relationship across Domains Stores and Accounts between Store and Employee. The Join Rescue is in the Stores Domain. Here is the definition of the Store → Employee many_to_many has_many :employees_join_assoc, PointOfSale.Stores.StoreEmployee, public?: true many_to_m…

It isn’t limited to Ash GraphQL: Ash.get!(Store, "34e45990-b109-4bd3-ab97-da4366af1be0", tenant: "dreambean", load: [:employees]) [debug] QUERY OK source="stores" db=2.3ms idle=1844.1ms SELECT s0."id", s0."name", s0."created_at", s0."updated_at" FROM "dreambean"."stores" AS s0 WHERE (s0."id"::uu…

Without the load the query doesn’t fail. I noticed that in the query with the load that the stores query isn’t using the tenant schema. In contrast: The query without the load uses: FROM "dreambean"."stores" Ash.get!(Store, "34e45990-b109-4bd3-ab97-da4366af1be0", tenant: "dreambean") [debug] QUERY…

I put Employee into the Stores domain to rule that out, same error

Hmm, it looks like the schema in the table reference is missing when doing the load. Can you please open an issue on GitHub for this?

@BryanJBryce do all three resources have context(schema) based multi tenancy configured? I’m trying to reproduce this but having trouble.

nvm I got it reproduced :slight_smile:

Elixir Programming Language Forum

Error when reading many_to_many relationship

Questions & Help Questions

zachdaniel June 10, 2024, 4:22pm 7

nvm I got it reproduced