Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17043

Sorting data tables by date not working

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7
    • Fix Version/s: 4.7
    • Component/s: CiviEvent, Core CiviCRM
    • Labels:
      None
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      Some tables, such as the event overview on /civicrm/event/manage and the Memberships and Notes tabs for a contact, allow sorting by date using JQuery DataTables.
      In a non-English installation, sorting by date produces a random result because the localized dates can't be parsed (see screenshot). Adding a data-order attribute to the cell solves this issue.
      This pull request does just that: https://github.com/civicrm/civicrm-core/pull/6534

      This is only a minor bug, but it must have existed since datatables were introduced and it's not the first one I've encountered lately that only occurs when using CiviCRM in another language. I think it would be good if developers tested their work in at least one other language before deploying it.

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              klevie Kevin Levie
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: