Default Order on Date Column and Time Column

mrprice22

I'm trying to get my data table to initialize on 2 columns, one is a date column (9/6/2018) and the other is time column (6:30 AM). I have the date column working but I can't seem to get the time column working.

http://cyclegeekdev.com/osl/classes.php

Thanks,
Mark

colin

Hi @mrprice22 ,

I just took a look and it looks like it's working as expected to me.

If you sort just ascending on column 5, the time field, then you get the earliest times at the top, latest at the bottom.

You're sorting on

"order": [[ 3, "asc" ], [ 5, "asc" ]],

This means that for each day, the earliest days at the top, you get each of the days ordered. That's what I'm seeing. What were you expecting to see instead of what it is doing?

Cheers,

Colin

mrprice22

Actually, I made some updates and I got it to work sorting on hidden fields. But I didn't know how to delete my question.

colin

Best bet is to just reply and say - happens all the time...