title: PHP | LARAVEL | EloquentDataTable datatable query always returning 10 rows to the max
body: <p>I'm trying to show the list of productOrders based on an order ID within one of my view. Here's the code snip from my app/Datatables/ProductOrderDatatables.php which i use to pull the list from my database table called &quot;product_order&quot; :</p>
  <pre><code>public function dataTable($query)
  {
          $dataTable = new EloquentDataTable($query);           
          $columns = array_column($this-&gt;getColumns(), 'data');
          $dataTable = $dataTable
              -&gt;editColumn('price', function ($productOrder) {
                  return getPriceColumn($productOrder);
              })
              -&gt;rawColumns(array_merge($columns));
          
          return $dataTable;   
  }
  </code></pre>
  <p>Here's my query function within the ProductOrderDatatables.php :</p>
  <pre><code>public function query(ProductOrder $model)
  {
                
         return $model-&gt;newQuery()-&gt;with(&quot;product&quot;)
          -&gt;where('product_orders.order_id', $this-&gt;id)
          -&gt;select('product_orders.*')-&gt;orderBy('product_orders.id', 'desc');
  }
  </code></pre>
  <p><strong>Problem :</strong></p>
  <p>-&gt; Consider, I try to pull an order with order_id = 314
  -&gt; Here's how the entries look like within the database :
  <a href="https://i.stack.imgur.com/sEDpf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sEDpf.png" alt="enter image description here" /></a>
  -&gt; I get <strong>ALWAYS</strong> 10 results to the <strong>MAXIMUM</strong>. As you could see there are <strong>11</strong> entries , but i always get capped at 10. I don't understand where i should be looking for limit for <code>new EloquentDataTable($query)</code> if at all there's one.</p>
  <p>Does somebody have an idea about what i should be looking ?? Running a raw SQL query within the datatabase SQL section returns all 11 as expected. Any hints/suggestions/solutions please ??</p>
  <p><strong>Packages list</strong></p>
  <ul>
  <li>namespace App\DataTables;</li>
  <li>use App\Models\CustomField;</li>
  <li>use App\Models\ProductOrder;</li>
  <li>use App\Models\Product;</li>
  <li>use Barryvdh\DomPDF\Facade as PDF;</li>
  <li>use Yajra\DataTables\EloquentDataTable;</li>
  <li>use Yajra\DataTables\Services\DataTable;</li>
  <li>use Illuminate\Support\Facades\Log;</li>
  <li>use DB;</li>
  </ul>