[Koha-bugs] [Bug 26233] Edit item date sort still does not sort correctly
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Aug 19 19:44:41 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26233
--- Comment #13 from Ivan Dziuba <ivan.dziuba at inlibro.com> ---
(In reply to Jonathan Druart from comment #12)
> Hi Ivan, please try with the 4 dates from comment 6 and with the system
> preferences dateformat set to "us"
Hi Jonathan, sorry I don't have biblionumber = '4', but I have more than 4
dates for biblionumber = '66343' and it works nice...
T-SQL:
select itemnumber, dateaccessioned from items where biblionumber = '66343';
+------------+-----------------+
| itemnumber | dateaccessioned |
+------------+-----------------+
| 75554 | 2014-11-25 |
| 75555 | 2014-12-17 |
| 75556 | 2014-12-17 |
| 75557 | 2015-01-28 |
| 75558 | 2015-02-21 |
| 75559 | 2015-03-17 |
| 75560 | 2015-04-14 |
| 75561 | 2015-05-21 |
| 75562 | 2015-06-11 |
| 75563 | 2015-08-28 |
| 75564 | 2015-10-13 |
| 75565 | 2015-11-19 |
| 75566 | 2016-01-06 |
| 75567 | 2016-02-11 |
| 75568 | 2016-03-15 |
| 75569 | 2016-04-13 |
| 75570 | 2016-05-07 |
| 75571 | 2016-06-15 |
| 75572 | 2016-08-19 |
| 75573 | 2016-09-21 |
| 75574 | 2016-11-23 |
+------------+-----------------+
https://prnt.sc/u2dabp
Thanks!
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list