[SOLVED] How can I get soft deleted entity from typeorm postgreSQL?


I am trying to get soft deleted doc from postgreSQL database using typeorm 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
        .leftJoinAndSelect('folder.subStatus', 'status')

Answered By – BunyamiN

Answer Checked By – Katrina (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published. Required fields are marked *