Get hidden field from database using NestJs

Question

I applied hidden property on password:

 @Column({nullable: true, select: false})
 password: string;

Doing the login i need the password filed. So according to he documentation i can select this hidden value by using:

const qb = getConnection().createQueryBuilder()
const user = await qb
  .select("password", "password")
  .from(User, 'user')
  .where("password = :password", {
    password: password
  })
  .addSelect('password', 'password')
  .getOne()

Doing this i get undefined and the password property anyway remains hidden.
How to get hidden values in my situation?

Edward · Accepted Answer · 2021-02-15 16:56:35Z

1

According to the documentation you can select hidden value by using

.addSelect('user.password')

You have .addSelect('password', 'password') which will not work. Do not alias the columns for hidden columns. (Probably a bug in TypeOrm).

This will also work

   .select('user.password')

You don't need both select and addSelect for the same columns, the addSelect does nothing since the columns are already selected.

answered Feb 15, 2021 at 16:56

Edward

8,7042 gold badges42 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Asking Over a year ago

could you help please stackoverflow.com/questions/66537012/…

Collectives™ on Stack Overflow

Get hidden field from database using NestJs

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related