Default Order on Date Column and Time Column

Default Order on Date Column and Time Column

mrprice22mrprice22 Posts: 10Questions: 4Answers: 0

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

Answers

  • colincolin Posts: 4,694Questions: 0Answers: 823

    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

  • mrprice22mrprice22 Posts: 10Questions: 4Answers: 0

    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.

  • colincolin Posts: 4,694Questions: 0Answers: 823

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

Sign In or Register to comment.