https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24533
Andrew Fuerste-Henry <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Andrew Fuerste-Henry <[email protected]> --- Created attachment 99765 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=99765&action=edit sorting screenshot This did get a little weird on me. I checked out four things and then updated issuedate and date_due for some of them, ending up with these values: select issue_id, issuedate, date_due from issues order by issuedate; +----------+---------------------+---------------------+ | issue_id | issuedate | date_due | +----------+---------------------+---------------------+ | 4 | 2020-02-19 14:17:00 | 2020-03-05 23:59:00 | | 1 | 2020-02-21 14:17:00 | 2020-03-04 23:59:00 | | 2 | 2020-02-28 14:17:44 | 2020-03-24 23:59:00 | | 3 | 2020-02-28 14:17:50 | 2020-04-29 23:59:00 | +----------+---------------------+---------------------+ Sorting looked ok to me except for when I tried to sort by Checked Out On (see attached screenshot). It looks like it might just be sorting on issue_id rather than date? +----------+---------------------+---------------------+ | issue_id | issuedate | date_due | +----------+---------------------+---------------------+ | 1 | 2020-02-21 14:17:00 | 2020-03-04 23:59:00 | | 2 | 2020-02-28 14:17:44 | 2020-03-24 23:59:00 | | 3 | 2020-02-28 14:17:50 | 2020-04-29 23:59:00 | | 4 | 2020-02-19 14:17:00 | 2020-03-05 23:59:00 | +----------+---------------------+---------------------+ I suppose in the real world sort by issue_id should be a reliable way to sort on checkout order, but it does open up some possible confusion if libraries are out there updating things from the database. -- 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/
