Laravel：在查询构建器咨询中获取softdeleted行

Question

How do I get a row that was sofdeleted for example This is my code:

$mov = $emp->movimientos()->where('movimiento.linea_id', intval($request->id_caso))->with('producto_nombre', 'costo_promedio');

I have this consult, one movimientos is related with a costo_promedio, but if in some case acosto_promedio is softdeleted the result in my consult $mov will give me null in the part of costo_promedio. The thing is, where do I have to puth the withTrashed() method to get all data even the ones that were softdeleted

Thx for the help

Answer 1

Use with() with a closure:

$mov = $emp->movimientos()
    ->where('movimiento.linea_id', intval($request->id_caso))
    ->with([
        'producto_nombre',
        'costo_promedio' => function($query) {
            $query->withTrashed();  
        }
    ]);