BryanJBryce

BryanJBryce

Error when reading many_to_many relationship

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_many :employees, PointOfSale.Accounts.Employee do
      through PointOfSale.Stores.StoreEmployee
      domain PointOfSale.Accounts
      source_attribute_on_join_resource :store_id
      destination_attribute_on_join_resource :employee_id
      public? true
    end

When trying to read the relationship via GraphQL I get the following error:

** (FunctionClauseError) no function clause matching in anonymous fn/2 in Ash.Actions.Read.Relationships.attach_related_records/2

    (ash 3.0.10) lib/ash/actions/read/relationships.ex:29: anonymous fn({:__exception__, %Postgrex.Error{
        message: nil,
        postgres: %{
            code: :undefined_table,
            line: "1452",
            message: "relation \"stores\" does not exist",
            position: "39",
            file: "parse_relation.c",
            unknown: "ERROR",
            severity: "ERROR",
            pg_code: "42P01",
            routine: "parserOpenTable"
        },
        connection_id: 46035,
        query: "SELECT DISTINCT s0.\"id\", s1.\"id\" FROM \"stores\" AS s0 INNER JOIN LATERAL (SELECT se0.\"id\" AS \"id\" FROM \"dreambean\".\"employees\" AS se0 INNER JOIN \"dreambean\".\"store_employees\" AS ss1 ON ss1.\"employee_id\" = se0.\"id\" WHERE (ss1.\"store_id\" = s0.\"id\")) AS s1 ON TRUE WHERE (s0.\"id\" = ANY($1))"
    }, [

The join resource:

  relationships do
    belongs_to :store, PointOfSale.Stores.Store do
      primary_key? true
      allow_nil? false
      public? true
    end

    belongs_to :employee, PointOfSale.Accounts.Employee do
      domain PointOfSale.Accounts
      primary_key? true
      allow_nil? false
      public? true
    end
  end

Marked As Solved

zachdaniel

zachdaniel

Creator of Ash

Fixed in ash_postgres main.

Where Next?

Popular in Questions Top

minhajuddin
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
New
lessless
I believe there are people here who are dealing with CSV files import on the daily basis, and since Excel is a really popular tool there ...
New
PeterCarter
There are pre-rolled solutions for other frameworks that do work. However, Phoenix does not seem to have these. Have people had good expe...
New
bsollish-terakeet
Credo is smart enough to check for (something like) this: assert length(the_list) == 0 with this response: Checking if an enum is empt...
New
shijith.k
I am trying to start a new phoenix project with elixir 1.9, but mix phx.new does not work. It says that ** (Mix) The task "phx.new" could...
New
siddhant3030
Hi, I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw ...
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New

Other popular topics Top

nobody
Hi! In PHP: $_SERVER[‘SERVER_ADDR’] - in Elixir? Searched the docs for ip address and the web, no good results. Thanks!
New
chrismccord
Phoenix 1.4.0 released Phoenix 1.4 is out! This release ships with exciting new features, most notably with HTTP2 support, improved deve...
688 31586 112
New
AngeloChecked
What learn first? Rust or Elixir Hi Elixir community! I’m here because i want learn a new language. I’m a junior developer and mainly i ...
New
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID<0.412.0> terminating ** (Postgrex.Error) FATAL...
New
Harrisonl
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service. Currently when I de...
New
AstonJ
Posting this to see if we can make things easier for people to get into Neovim. If you use Neovim and have a favourite distro please let ...
New

We're in Beta

About us Mission Statement