Display date in descending order in AngularJS datatables

Question

I have a list of dates coming from API and one such date is like "2017-07-05T10:53:24.000Z"

Am displaying dates in first column in datatable. In controller am defining the column like

$scope.dtColumnDefs = [
        DTColumnDefBuilder.newColumnDef(0).withOption('type', 'date'),
        DTColumnDefBuilder.newColumnDef(1).notSortable(),
        ....
];

HTML

<table datatable="ng" dt-options="dtOptions" dt-column-defs="dtColumnDefs">
                <thead>
                    <tr class="table-header-color-yellow">
                        <th class="table-head-style">Date</th>
                    </tr>
                </thead>
                <tbody>
                    <tr ng-repeat="review in reviews">
                        <td>{{review.date | date}}</td>
                    </tr>
                </tbody>
            </table>

How can i sort the dates in descending order as it is sorting in ascending order as of now?

docs.angularjs.org/api/ng/filter/orderBy

Aayushi Jain
– Aayushi Jain

2017-07-12 08:00:24 +00:00
Commented Jul 12, 2017 at 8:00 — Aayushi Jain
– Aayushi Jain, Commented Jul 12, 2017 at 8:00

davidkonrad · Accepted Answer · 2017-07-13 12:54:40Z

4

Just set the order option :

$scope.dtOptions = DTOptionsBuilder.newOptions()
  .withOption('order', [[0, 'desc']])

Your usage of columnDefs is a little bit wrong. It should be

$scope.dtColumnDefs = [
  DTColumnDefBuilder.newColumnDef(0).withOption('type', 'date').notSortable()
];

answered Jul 13, 2017 at 12:54

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

Comments

Liyaquet Hussain · Accepted Answer · 2017-07-12 08:04:04Z

0

Convert date part into dd/MM/yyyy

Then in controller use

$scope.dtColumnDefs = [  
    DTColumnDefBuilder.newColumnDef([1]).withOption('type', 'date')
];

and Html should be like this

<table class="table table-hover" datatable="ng" dt-column-defs="dtColumnDefs">

answered Jul 12, 2017 at 8:04

Liyaquet Hussain

1015 bronze badges

Collectives™ on Stack Overflow

Display date in descending order in AngularJS datatables

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related