title: Server Side Processing Dynamic Columns
body: <p>Server side path provides a 404 error where path is same as used on initial loading of the table.  The table is destroyed and the columns are dynamically changed. </p>
  
  <p>I successfully apply server side processing where I have static columns.  I have previously built the table dynamically without server side processing but the load is too large now for it to handle.  Therefore I have moved to SQL paging with server side processing configuration but it will not load the table even thought the path is the same as it is when I initially load the table but with one static column. I am using version 1.10.15 due to how long I have been using the library and I have many tables that I am concerned will no longer work if I upgrade.  Not sure upgrading will fix the problem either.</p>
  
  <p>JQuery Datatables code</p>
  
  <pre><code>var oTable = $("#InvoiceProcessing").DataTable({
                  jQueryUI: true,
                  pagingType: "full_numbers",
                  responsive: true,
                  "scrollX": true,
                  "bServerSide": true,
                  "sAjaxSource": "@Url.Action("GetInvoiceProcessing", "InvoiceProcessing")?clientId=" + cId + "&amp;summaryDate=" + sumDate + "&amp;processedDate=" + procDate + "&amp;accountNumber=&amp;invoiceNumber=",
                  "bProcessing": true,
                  "destroy": true,
                  lengthMenu: [[25, 50, 100], [25, 50, 100]],
                  "autoWidth": true
              });
  </code></pre>
  
  <p>C# method signature - This method does not get hit</p>
  
  <pre><code>public async Task&lt;ActionResult&gt; GetInvoiceProcessing(Guid? clientId, DateTime? summaryDate, DateTime? processedDate, DataTableParamModel param, string accountNumber = "", string invoiceNumber = "")
  </code></pre>
  
  <p>I need to have the paging reflect the full size of the query.  I am using sql paging which returns a total record count and only the page length of data.  If I can accomplish this without server side processing I would be happy with that as well.</p>