Hi,
i am using sharepoint 2019 ( on prem ), with Jsom to retrieve and bind data
using bootstrap with datable to bind with html table on dropdown change
Problem:
i have date column which contains index no 1 on datatable ,having format "DD-MM-YYYY hh:mm A".
I have applied sort but its not working on "DD-MM-YYYY hh:mm A", instead working fine on "MM-DD-YYYY hh:mm A".
Solution required: how can i sort it on desc order default on "DD-MM-YYYY hh:mm A" , then allow user to make it asc and desc on column click , as we do usual
Code Sample :
<pre>datefinal = moment(oListItem.get_item('Created')).format('DD-MM-YYYY hh:mm');
newRow = '<tr id=tr_' + oListItem.get_item('ID') + '> <td> <a href="#" onclick="opendoc(' + oListItem.get_item('ID') + ",'DebtDocs','tblPrivatePlace'" + ');" > ' + oListItem.get_item('FileLeafRef') + ' </a> </td> <td>' + datefinal + '</td>
// $("#tblPrivatePlace").append(newRow);
var table = $(tablename).DataTable();
table.row("#tr_" + oListItem.get_item('ID')).remove().draw(false);
////
var table = $(tablename).DataTable();
table.row.add($(newRow)).draw();
table.order([1, 'desc']).draw();
Please guide
Thanks
What I have tried:
applied on load not working like document.ready()