Date sorting not working no matter what I try.

  • Resolved robinbuzios

    (@robinbuzios)


    6 years, 3 months ago

    First of all, your plugin is exactly what I needed, and I’m so glad I found it! I have searched and read through all possible solutions to sorting issues. I am using the DataTables Sorting plugins, and using the custome code “”columnDefs”: [ { “type”: “date-eu”, “targets”: [ 0, 1 ] } ]”. The column only sorts based on the “dd” portion of “dd/mm/yyyy”.
    I am testing it in conjuction with Store Exporte Deluxe from Visser Labs, which has several settings, including:

    Escape all cells – This will write field data exactly as it is saved in the database, regardless of the field type/format.

    Escape cells as Excel would – This will change field data when writing to export file, just the same way Excel changes field data when you import CSV into Excel (Caution: this may mess up phone numbers and postcodes with leading zeroes).

    Do not escape any cells – This will not change any field data when writing to export file (Caution: this may mess up text fields containing the delimiter character).

    However none seem to make a difference. I will definitely donate if I can get this to work! ??

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I can’t reproduce this. When I visit this page, the first column (“data”) is nicely sorting the dates.

    Regards,
    Tobias

    Thread Starter robinbuzios

    (@robinbuzios)

    Thank you friend! I went through hours of confusion until I found out that the back end doesn’t sort… only on the front end! Thank you, and great work! The only thing left is to figure out how to filter dates to only show today, but apparently can’t do this with “dd-mm-yy” format.

    • This reply was modified 6 years, 3 months ago by robinbuzios.
    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ah, indeed. These sorting instructions only ever affect the frontend sorting.

    I’m not sure what you mean with this filtering issue here. Which filtering do you mean, and what exactly is not working with it?

    Regards,
    Tobias

    Thread Starter robinbuzios

    (@robinbuzios)

    Thank you for your responses! To be more clear, I think the term might be “pre-filter” so I can get the table to only show entries corresponding to the current day. I do airport transfers and only want my providers to see entries for the current day.
    I read somewhere that maybe this can’t be done using the dd/mm/Y format.
    Thanks,
    Rob

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Rob,

    ok, how are you doing this pre-filtering? Are you using a TablePress Extension for it? (There is indeed one for this, see https://www.ads-software.com/support/topic/display-by-date/ . It does only support the mm/dd/yyyy date format, but you could simply include two date columns here (one for each format) and hide the mm/dd/yyyy column with CSS code.)

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Date sorting not working no matter what I try.’ is closed to new replies.