Support the ongoing development of Laravel.io →
API Laravel.io

I'm trying to make a filter to return only the results with status_pedido 'pendente' and 'recebido'. How do I pass these two parameters?

  `public function listPending(Request $req){

   
   $pedidos = Pedido::with('itensPedido')->where('status_pedido', 'recebido');

  return response()->json($pedidos);
   }`

my code is like this. I was wondering if there is a way to pass the two parameters inside the 'where' method.

I tried to do it this way. It worked, but I don't think it's the best way:

  `public function listPending(){

   $recebidos = Pedido::with('itensPedido')->where('status_pedido', 'recebido')->get();
   $pendentes = Pedido::with('itensPedido')->where('status_pedido', 'pendente')->get();

     $array = [
        $recebidos,
        $pendentes
     ];
   return response()->json($array);
    }`
Last updated by @celohenryz 3 years ago.

celohenryz liked this thread

1

I managed to do it this way:

   $pedidos = Pedido::with('itensPedido')->whereIn('status_pedido', array('recebido', 'pendente'))->get();
    return response()->json($pedidos);
0
Solution selected by @driesvints

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.