wherein clause not working pagination laravel

    By: Manu
    3 years ago

    Hi i got a way around to this problem

    i used foreach loop to filter data so instead whereIn with paginator. I Used multiple where clauses something like this

    $changeData =  Audit::where('somevalue','=','something');
    
    
    foreach($something as $index =>$value)
    {
        if($index == 0){
          $changeData = $changeData->where('id',$value);
        }else{
          $changeData = $changeData->orWhere('id',$value);
    }
    
    $changeData = $changeData->paginate(20);
    


    This way i got my id filtered before paginator generated, I tried whereIn but it was not working.