[Koha-bugs] [Bug 24533] Improved sorting in checkouts table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24533

Andrew Fuerste-Henry <andrew at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |andrew at bywatersolutions.com

--- Comment #4 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
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.