yajra · abudawud · Dec 22, 2023 · yajra · Dec 28, 2023
diff --git a/response-with.md b/response-with.md
@@ -66,6 +66,9 @@ Route::get('user-data', function() {

 	return DataTables::eloquent($model)
 				->withQuery('count', function($filteredQuery) {
+					// remove limit and offset firstly
+					$filteredQuery->limit = null;
+					$filteredQuery->offset = null;
 					return $filteredQuery->count();
 				})
 				->toJson();
-Original file line number
+Diff line change
@@ -66,6 +66,9 @@ Route::get('user-data', function() {
     	return DataTables::eloquent($model)
     				->withQuery('count', function($filteredQuery) {
+    					// remove limit and offset firstly
+    					$filteredQuery->limit = null;
             Copy link

  
      
    
  

  
      

  
    Owner


      

  

  
    
      

      
            yajra
  

      

      

      


        Dec 28, 2023


      
  •

  
    
      
        
          edited
          
        
        
      
    
    
      
  
        
      Loading


  
    
  
    
      

              Uh oh!

              
There was an error while loading. Please reload this page.


  
  
    
  


    

  


        
      
  
  
  
    

    There was a problem hiding this comment.


  

 
  
    

    Choose a reason for hiding this comment

    
      The reason will be displayed to describe this comment to others. Learn more.
    

    
      
      


  


  
    
      When using eloquent builder, this works instead.
$query->getQuery()->limit = 0;
$query->getQuery()->offset = 0;
    
  
  


    

        
      
  
  
    
  
  
  
    
    Sorry, something went wrong.
  

  
    
  
    
      

              Uh oh!

              
There was an error while loading. Please reload this page.


  
  


          
      
  
    
    
      
        
            
    All reactions
+    					$filteredQuery->offset = null;
     					return $filteredQuery->count();
     				})
     				->toJson();
-          Expand Down