Home / Questions / 352208
Accepted
Luis
Asked: 2020-05-05 11:14:55 +0800 CST 2020-05-05 11:14:55 +0800 CST

Remove certain fields from a table with the same id

  • 772

I have two tables in which I want to delete certain fields from a table related to another

a table is called procesess and another diligences and I want to eliminate all the fields that have in status_diligence the values ​​of: pending, rejected, sent there is another value that is approved but the fields with that value must remain

I have tried this but it does not work or it deletes all those with that id even if it has the value of approved

attempt1

$diligences = Diligence::where('process_id', "=", $id)->delete([
    ['status_diligence', "=", "pendiente"],
    ['status_diligence', "=", "rechazado"],
    ['status_diligence', "=", "enviado"]
]);

attempt 2

$diligences = Diligence::select('process_id', $id)
                        ->where(function($q) {
                            $q->where('status_diligence', 'pendiente')
                            ->where('status_diligence', 'rechazado')
                            ->where('status_diligence', 'enviado');
                        })
                        ->delete();
laravel

1 Answers

  1. Best Answer

    Since you want to remove from the entity Diligencebased on value matching criteria then you can make use of the whereIn.

    The above method will ask you:

    • Name of the column where you are looking to find the matches
    • An array with the values ​​you expect to find as matches

    So your query could look like this:

    $eliminados = Diligence::whereIn('status_diligence', ['pendiente', 'rechazado', 'enviado'])
                        ->delete();

    Now if apart from this filter you need to add the foreign key that is: process_idyou will only have to chain a method wherebetween it whereInand deletein this way:

    Code:

    $eliminados = Diligence::whereIn('status_diligence', ['pendiente', 'rechazado', 'enviado'])
                        ->whereProcessId($id)
                        ->delete();
    • 3