To retrieve soft-deleted entities in TypeORM PostgreSQl, you can use the find
method with an additional withDeleted
method. Here is an example:
const deletedEntities = await repository.find({ withDeleted: true });
This will fetch all the entities, including the ones that were soft-deleted. You can also filter the retrieved entities further by using the where
option.
const deletedEntities = await repository.find({
withDeleted: true,
where: { deletedAt: Not(null) }
});
This will retrieve all the entities that have a deletedAt
field with a value, indicating that they have been soft-deleted.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-05-16 06:16:21 +0000
Seen: 15 times
Last updated: May 16 '23
How can the SQL debug mode be activated in PostgreSQL version 15.2?
What is the procedure for using pg_restore on Windows with Docker?
What is the equivalent of SQL Server NVARCHAR in PostgreSQL?
What is the method to retrieve the JSON data from a column in SQL?
How to solve the issue of being unable to establish a connection with libpq on Mac M1?
Is it possible to launch multiple instances of PostgreSQL using Spring Boot Testcontainers?
Due to SyntaxError, why am I unable to create a TIMESTAMP WITH TIMEZONE column in postgres?