Selecting fields in preloaded joins Ecto

[shahryarjb]

@benwilson512

query = from u in UserSchema, where: u.id == ^id, left_join: c in assoc(u, :subscribers), preload: [subscribers: c], select: struct(c, [ :id, :name, :mobile, :last_name, :mobile, :status, :role, :inserted_at, :updated_at, :subscribers, ])

** (Ecto.QueryError) the binding used in `from` must be selected in `select` when using `preload` in query:

from u0 in BankError.ClientApi.Auth.UserSchema,
  left_join: s1 in BankError.ClientApi.Factor.SubscriberSchema,
  on: s1.user_id == u0.id,
  where: u0.id == ^...,
  select: struct(s1, [:id, :name, :mobile, :last_name, :mobile, :status, :role, :inserted_at, :updated_at, :subscribers]),
  preload: [subscribers: s1]

    (ecto) lib/ecto/repo/queryable.ex:132: Ecto.Repo.Queryable.execute/4
    (ecto) lib/ecto/repo/queryable.ex:18: Ecto.Repo.Queryable.all/3
    (ecto) lib/ecto/repo/queryable.ex:66: Ecto.Repo.Queryable.one/3