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…

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

BryanJBryce June 7, 2024, 10:32pm 4

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