I Can't search the date, even rendering the column in the client side, what is wrong in my code?

kenionatan

Server side:

<?php

$table = 'invoices';
$primaryKey = 'doc';
 
$columns = array(
    array( 'db' => 'doc', 'dt' => 0 ),
    array( 'db' => 'serial_doc',  'dt' => 1 ),
    array( 'db' => 'register',  'dt' => 2 ),
    array( 'db' => 'issue_date',  'dt' => 3 )
);

Client side:

$(document).ready(function(){
        var table = $('#example').DataTable({
            "processing": true,
            "serverSide": true,
            "ajax": {
                "url": "http://localhost:911/portal_fornecedor/portal/processing_month.php",
            },
            columns: [
                {"data": 0},
                {"data": 1},
                {"data": 2},
                {
                    data: 3,
                    render: function(data, type, row){
                        if(type === "sort" || type === 'type'){
                            return data;
                        }
                        return moment(data).format("DD/MM/YYYY");
                    }
                }
           ]
       });
});

The date is displayed in this format: DD/MM/YY, but only is searchable in the original format: YYYY-MM-DD

kthorngren

You have serverSide": true, which requires the server to perform the search. You will need to convert the DD/MM/YY formatted search term to something that works with your backend data.

Kevin

kenionatan

using the serverSide: true, what can I do so I can sort and search formatted date (DD/MM/YYYY) ?