title: Datatables only shows 15 data
body: <p>I'm using datatables to show my data from db. The problem is the datatables only shows 15 data, even though I already add a new data, it will only shows 15 data and in the db itself there are more than 15 data. Why my datatables only show 15 data?</p>
  <p>Here is my code:</p>
  <pre><code>$('#tabelpekerjaan').DataTable({
        &quot;paging&quot;: true,
        &quot;lengthChange&quot;: true,
        &quot;searching&quot;: true,
        &quot;ordering&quot;: true,
        &quot;info&quot;: true,
        &quot;autoWidth&quot;: true,
        &quot;responsive&quot;: true,
        
        initComplete: function(){
          this.api()
              .columns([0])
              .every(function(){
                var column = this;
                var select = $('&lt;select&gt;&lt;option value=&quot;&quot;&gt;Semua&lt;/option&gt;&lt;/select&gt;')
                    .appendTo('#tahun')
                    .on('change',function(){
                      var val = $.fn.dataTable.util.escapeRegex($(this).val());
   
                              column.search(val ? '^' + val + '$' : '', true, false).draw();
                    });
  
                    column
                      .data()
                      .unique()
                      .sort()
                      .each(function(d,j){
                        select.append('&lt;option value=&quot;' + d + '&quot;&gt;' + d + '&lt;/option&gt;');
                      });
  
                      $( select ).click( function(e) {
                   e.stopPropagation();
             });
              });
        }
      });
  </code></pre>
  <p>I have already tried suggestion from this post that I've found, <a href="https://stackoverflow.com/questions/55948723/datatables-only-shows-15-when-i-have-60">Datatables only shows 15 when I have 60</a> , but it doesn't work...</p>