Selecting fields in preloaded joins Ecto

One more typo, try again.

I have this error,

** (Postgrex.Error) ERROR 42703 (undefined_column) column u0.subscribers does not exist

    query: SELECT u0."id", u0."name", u0."mobile", u0."last_name", u0."mobile", u0."status", u0."role", u0."inserted_at", u0."updated_at", u0."subscribers", s1."id", s1."expire_time", s1."status", s1."user_id", s1."inserted_at", s1."updated_at" FROM "users" AS u0 LEFT OUTER JOIN "subscribers" AS s1 ON s1."user_id" = u0."id" WHERE (u0."id" = $1)
    (ecto_sql) lib/ecto/adapters/sql.ex:605: Ecto.Adapters.SQL.raise_sql_call_error/1
    (ecto_sql) lib/ecto/adapters/sql.ex:538: Ecto.Adapters.SQL.execute/5
    (ecto) lib/ecto/repo/queryable.ex:147: 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

it should be noted I fixed my problem with long way but if it works I think my code will be Shorter

oops, I had a typo, fixed!

** (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

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

I mean the user hash password and shows the user status, I want to show my user the query selected.
if I call the u: u in my select this problem will be solved like this

   query = from u in UserSchema,
       where: u.id == ^id,
       left_join: c in assoc(u, :subscribers),
       preload: [subscribers: c],
       select: %{
         u: u,
         user_info: %{
           id: u.id,
           name: u.name,
           mobile: u.mobile,
           last_name: u.last_name,
           mobile: u.mobile,
           inserted_at: u.inserted_at,
           updated_at: u.updated_at,
         }
       }

   Repo.one(query)

but it shows me Users all fields again

When you say the user password, do you mean the user password hash or the user’s actual password? The user’s actual password should never, EVER be stored in the database.

if I use this, it shows me user password I need to select fields I want not all of them

query = from u in UserSchema,
       where: u.id == ^id,
       left_join: c in assoc(u, :subscribers),
       preload: [subscribers: c]

   Repo.one(query)

Hello, I have a problem when I want to use select in preload, please see this code

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

and error:

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

I should use select on UserSchema, how can I fix this ?