Make non displayable data to appear in the bottom of the table

Make non displayable data to appear in the bottom of the table

jt4000jt4000 Posts: 7Questions: 4Answers: 0

Goal:
Any cell that do not contain any data (null or whitepsace) should be always be located at the bottom of the table when you use ASC or DESC.
It should be happening on a specific column and the remaining column should not be affected.
The specific column is 'Name'

Problem:
I do not know how to do it and is it possible to do it in relation to this Cloudtables?

JSbin:
https://jsbin.com/jacewudaji/edit?html,outpout

Thank you!


Code below

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/dt-1.10.25/datatables.min.css"/>

Name Position Office Age Start date Salary
Name Position Office Age Start date Salary
var data = [ [ null, "System Architect", "Edinburgh", "5421", "2011/04/25", "$3,120" ], [ "Jim Winters", "Director", "Edinburgh", "8422", "2011/07/25", "$5,300" ], [ "Garrett Winters", "Director", "Edinburgh", "8422", "2011/07/25", "" ], [ "", "Director", "Edinburgh", "8422", "2011/07/25", "" ], [ "Jim West", "Director", "Edinburgh", "8422", "2011/07/25", "" ], [ "Sandra Brown", "Director", "Edinburgh", "8422", "2011/07/25", "" ] ] $( document ).ready(function() { console.log( "ready!" ); }); $('#example').DataTable( { data: data, "columnDefs": [ { "targets": 0, type: 'sortme' } ] } ); $.fn.dataTable.ext.type.order['sortme-asc'] = function ( a) { // sorting logic here }; $.fn.dataTable.ext.type.order['sortme-desc'] = function ( a) { // sorting logic here };

</body>
</html>

Answers

Sign In or Register to comment.