Ordering by a datetime as 'timeago' about datatablesbundle HOT 6 CLOSED

Server- or clientside? Do you work with the master branch? If sorted incorrectly or any exception thrown?
Maybe should I implement the possibility to set the columns.type (http://datatables.net/reference/option/columns.type).

from datatablesbundle.

I've just updated to the latest master of this bundle, and my server-side based doesn't throw any exceptions. It's just ascii ordering the 'timeago' strings -

• "25 days ago"
• "4 days ago"
• "8 days ago"
• "8 hours ago"
• "9 days ago"
• "a month ago"

If there is some way that original date can be put for the sort field (as an epoch, or probably better, an ISO date), and the sort would base of of that, then it would probably be fine.

from datatablesbundle.

You can try the following in the render_timeago function (datatable.html.twig):

        function render_timeago(data, type, row, meta) {
            if ("display" === type) {
                if (typeof data.timestamp != "undefined") {
                    moment.lang("{{ app.request.locale }}");
                    return moment.unix(data.timestamp).fromNow();
                } else {
                    return null;
                }
            }

            return data;
        }

Unfortunately, we now have still a problem with the filter. The user would have to enter a date for that.

from datatablesbundle.

I've overridden the template (verifying it's being called OK), and changed the 'render_timeago' function, as above. The only difference I can see afterwards is that the column is now unsortable.

from datatablesbundle.

Ok ... I can not reproduce the issue (at the moment). I have a table of all users and let me show the last login as Timeago. The result:

• a few seconds ago
• 2 days ago
• 2 months ago
• 2 years ago

or

• 2 years ago
• 2 months ago
• 2 days ago
• 3 minutes ago

Please save the link from http://debug.datatables.net/ start the Debug and go to Tables->Columns->Full column details->Your Timeago Column()

Show me the result. Thank you.

from datatablesbundle.

I've just realised that it was not in fact a ServerSide(true) based system, so I have split into index and results actions to enable that. The timeago field does now sort properly with the updated template, though all the sorting is only page based - so in order to see the highest or lowest dates I would have to view all entries.

Oddly, I also have to enable a primary key column, though it does not have to be visible, or else the sort appears to just reverse the order that is on screen, without any change in the ordering by the column that is clicked.

from datatablesbundle.