public function complaint_pending(){

    $complaints = Complaint::whereNull('answear')->get();

    return view('admin.complaint.panding',compact('complaints'));

   }

I want to show Complaint all data which answer row is NULL

My DB pic is below

enter image description here

CodePudding user response：

That's not work but it's work perfectly ...

  public function complaint_pending(){
    
    $complaints = Complaint::where('answear', NULL)->get();
    
    return view('admin.complaint.panding',compact('complaints'));
    }

CodePudding user response：

try the following code

public function complaint_pending(){

$complaints = Complaint::where('answear',NULL)->get();

return view('admin.complaint.panding',compact('complaints'));

}