datatable.js fnServerParams is not working with parameterized array data

Question

I am using datatable.js with MVC4 web application. I am try to pass array data in fnServerParams.

Here I create a array object called array to passing data to server side.

Please see my code below:

function GetTaxInvoices(IsInital, TaxInvoiceIds) {

    alert("message : IsInital :- " + IsInital + " , TaxInvoiceIds :- " + TaxInvoiceIds);

    var elementName = "#tblCreatedTaxInvoices";

    ClearData(dtTable2);

    var array = [51, 52];

    ajaxUrl = (IsInital) ? null : '@Url.Action("GetCreatedTaxInvoices", "Invoice")';

    dtTable2 = $(elementName).dataTable({
        bProcessing: true,
        bLengthChange: false,
        sAjaxSource: ajaxUrl,
        traditional: true,
        "fnServerParams": function (aoData) {
            aoData.push(
                            { "name": "TaxInvoiceIds", "value": array }
            );
        },
        aoColumns: [
            { sTitle: "Id", bSortable: false, bVisible: false, },
            { sTitle: "PoBox Number", bSortable: false, },
            { sTitle: "Email", bSortable: false, },
            { sTitle: "Owner", bSortable: false, },
            { sTitle: "General Tax", bSortable: false, },
            { sTitle: "Consumption Tax", bSortable: false, },
            { sTitle: "Due Amount", bSortable: false, },
            { sTitle: "Date", bSortable: false, },
            { sTitle: "Detailes", bSortable: false, },
        ],
    });

}

But it always shows null.

enter image description here

Actually i try to pass a array in my Controller action. I already use '$.makeArray' but it's not working. — Ragesh Puthiyedath Raju
– Ragesh Puthiyedath Raju, Commented Jan 19, 2015 at 16:32
What happens if you change long[] TaxInvoiceIds to string[] TaxInvoiceIds or even just string TaxInvoiceIds? — markpsmith
– markpsmith, Commented Jan 19, 2015 at 16:33
Yes, it's working when i replace the 'string[] ' with 'string' , But you mean it's not possible to use a array ? — Ragesh Puthiyedath Raju
– Ragesh Puthiyedath Raju, Commented Jan 19, 2015 at 16:42

Viacheslav Yankov · Accepted Answer · 2015-02-02 13:07:56Z

1

try this:

 aoData.push(
      { "name": "TaxInvoiceIds[]", "value": array }
 );

https://github.com/DataTables/DataTablesSrc/commit/a3f57e4

or this: http://www.justinmichaels.net/custom-serverside-filtering-with-jquery-datables-and-asp-net-mvc3 (I am using this way).

edited Feb 2, 2015 at 13:07

answered Feb 2, 2015 at 11:18

Viacheslav Yankov

1,00612 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

datatable.js fnServerParams is not working with parameterized array data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related