I am trying to get soft deleted doc from
postgreSQL database using
find, findOne or query builder get/getMany methods, but it always return undefined. Is there a way to get deleted value?
By the docs it should only set a timestamp for
deletedAt, and it definitely works, because I can update same record using update where from query builder.
I found out there is another solution. You can use the querybuilders
.withDeleted() method to also return soft deleted entities.
const query = await this.manager .getRepository(FolderEntity) .withDeleted() .createQueryBuilder('folder') .leftJoinAndSelect('folder.subStatus', 'status') .getMany()
Answered By – BunyamiN
Answer Checked By – Katrina (BugsFixing Volunteer)