When I try to find a row that was soft deleted , even with {with_Deleted : true}
, returns null , but when the row was not soft-deleted it returns normal. Is there a way that it can return soft deleted rows?
conjunto-simulacoes service :
async getCorteById(id : number): Promise<ConjuntoSimulacoes>{
return await this.conjuntoSimulacoesRepository.findOne({withDeleted : true,relations : ['corte'],where : {id}});
}
conjunto-simulacoes Controller :
@Get('/corte/:id')
@UseGuards(AuthGuard('jwt'))
async getCorteBySimulacao(@Param('id') id : number){
return await this.conjuntoSimulacoesService.getCorteById(id);
}
conjunto-simulacoes entity :
@ManyToOne(() => Cortes , corte => corte.conjunto_simulacoes )
corte : Cortes;
cortes entity :
@OneToMany(() => ConjuntoSimulacoes , conjunto_simulacoes => conjunto_simulacoes.corte )
conjunto_simulacoes : ConjuntoSimulacoes[]
I fixed doing a new query , in my last query the {with_Deleted : true}
was searching inside the table conjunto simulacoes
and not in the table cortes
.
New query:
async getCorteByIdWithDeleted(id : number){
return await this.conjuntoSimulacoesRepository.query(`SELECT * FROM conjunto_simulacoes
as conjunto LEFT JOIN cortes as corte on corte.id = conjunto."corteId"
WHERE conjunto.id=${id}`);
}