List user messages logged in using Laravel

Question

Good afternoon.

I have in my Controller the method below:

public function lista () {        
    $mensagens =  Auth::user()->mensagens()->get();
    $title= "Mensagens";
    return view('auth.mensagens.lista',compact('mensagens','title'));
}

It returns a list of messages from the logged-in user. It turns out that in my data modeling, each message has a Boolean status of 0 or 1. How do I only return messages with status 1 ?

It must be something silly, but today I could not see a solution to this.

Grateful

Answer 1

You can add a where in your consultation.

public function lista () {        
    $mensagens =  Auth::user()->mensagens()->where('status', 1)->get();
    $title= "Mensagens";

    return view('auth.mensagens.lista', compact('mensagens', 'title'));
}