https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39015
David Nind <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Text to go in the| |This fixes date sorting for release notes| |the cash register | |statistics wizard so that | |columns with dates sort | |correctly (it adds a | |"data-sort" attribute to | |the columns in the results | |table which contain dates - | |this allows DataTables to | |sort using the unformatted | |date). It also adds the | |"anti-the" class to the | |title column, so that it | |sorts excluding articles | |such as a, the, and an. --- Comment #4 from David Nind <[email protected]> --- Testing notes using KTD: 1. I could replicate the date sorting issue with dates in the dd/mm/yyyy format, other date formats worked as expected. 2. Example query to update the date field: - koha-mysql kohadev - update accountlines set date="2025-01-15 12:00:00" where accountlines_id=3; - amend to reflect the data in your databases - list all transactions: select * from accountlines; - I amended the dates so that they were in different months and years 3. I amended the record titles to include the, a, and an at the start of the title - they now correctly sort by ignoring the article. 4. For the "Transaction type" field selector, I changed to "All transactions". -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
