CODEWITHSUNDEEP
javascriptphpjqueryhtmlajax
Konz Mama
Konz Mama

Reputation: 975

Datatables Format for Currency

I need to format a currency using commas in datatables JSON data. But I have got no luck, Please help me.

The code:

listReportByProductCat(function (json) {
    var table = $('#bycat_table').DataTable({
        "columnDefs": [
            { "visible": false, "targets": 1 }
            { "column": num-fmt, "targets": 3 } // PROBLEM HERE
        ],
        "order": [[ 1, 'asc' ]],
        "displayLength": 25,
        "drawCallback": function ( settings ) {
            var api = this.api();
            var rows = api.rows( {page:'current'} ).nodes();
            var last=null;

            api.column(1, {page:'current'} ).data().each( function ( group, i ) {
                if ( last !== group ) {
                    $(rows).eq( i ).before(
                        '<tr class="group"><td colspan="6"><b>'+group+'</b></td></tr>'
                    );

                    last = group;
                }
            } );
        },
        destroy: true,
        processing: true,
        data: json,
        "columns": [
            { "data": "Prod ID" },
            { "data": "catname" },
            { "data": "Product Name" },
            { "data": "Price" },
            { "data": "Qty" },
            { "data": "Total" }
        ]
    });

So the problem happened on target : 3, I followed datatables doc using num-fmt but still doesn't work. Please help.

Upvotes: 0

Views: 10190

Answers (1)

Naisa purushotham
Naisa purushotham

Reputation: 913

follow this link for sorting formatted data https://datatables.net/plug-ins/sorting/#formatted_numbers

 <script type="text/javascript" src="jquery.dataTables.js"></script>
    <script type="text/javascript" src="dataTables.numericComma.js"></script>
    <script type="text/javascript">
        $(document).ready(function() {
            $('#example').dataTable( {
                "columnDefs": [
                    { "type": "numeric-comma", targets: 3 }
                ]
            } );
        } );
    </script>

Upvotes: 1

Related Questions