[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Fridolin Somers changed: What|Removed |Added Blocks||28216 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28216 [Bug 28216] Fix vendor list group by in serials statistics wizard -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Lucas Gass changed: What|Removed |Added Status|Pushed to stable|Pushed to oldstable CC||lu...@bywatersolutions.com Version(s)|20.05.00, 19.11.06 |20.05.00, 19.11.06, released in||19.05.11 --- Comment #8 from Lucas Gass --- backported to 19.05.x for 19.05.11 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Joy Nelson changed: What|Removed |Added Status|Pushed to master|Pushed to stable Version(s)|20.05.00|20.05.00, 19.11.06 released in|| CC||j...@bywatersolutions.com --- Comment #7 from Joy Nelson --- backported to 19.11.x for 19.11.06 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Martin Renvoize changed: What|Removed |Added Status|Passed QA |Pushed to master Version(s)||20.05.00 released in|| -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 --- Comment #6 from Martin Renvoize --- Nice work everyone! Pushed to master for 20.05 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Jonathan Druart changed: What|Removed |Added Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Jonathan Druart changed: What|Removed |Added Blocks||17258 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMNIBUS] MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Jonathan Druart changed: What|Removed |Added Attachment #102401|0 |1 is obsolete|| --- Comment #5 from Jonathan Druart --- Created attachment 102533 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102533=edit Bug 24940: Serials statistics wizard: order vendor list alphabetically This patch changes the dropdown from being sorted by aqbookseller.id to aqbookseller.name To test: 1) Add at least 2 vendors: - First: - Second: 2) Add subscriptions for each of the vendors 3) Check the pull down in the serials statistics wizard and verify it lists them as , 4) Apply the patch 5) Re-check the pull down in the wizard and check that the vendors are now listed , Signed-off-by: Devinim Signed-off-by: Jonathan Druart -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Jonathan Druart changed: What|Removed |Added CC||jonathan.dru...@bugs.koha-c ||ommunity.org --- Comment #4 from Jonathan Druart --- And it even fixes a SQL error (with strict modes on) DBD::mysql::st execute failed: 'koha_kohadev.aqbooksellers.name' isn't in GROUP BY [for Statement "SELECT aqbooksellerid, aqbooksellers.name FROM subscription LEFT JOIN aqbooksellers ON (subscription.aqbooksellerid=aqbooksellers.id ) GROUP BY aqbooksellerid -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 --- Comment #3 from David Roberts --- Thanks Devinim! :-) -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Devinim changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 Devinim changed: What|Removed |Added Attachment #102390|0 |1 is obsolete|| --- Comment #2 from Devinim --- Created attachment 102401 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102401=edit Bug 24940: Serials statistics wizard: order vendor list alphabetically This patch changes the dropdown from being sorted by aqbookseller.id to aqbookseller.name To test: 1) Add at least 2 vendors: - First: - Second: 2) Add subscriptions for each of the vendors 3) Check the pull down in the serials statistics wizard and verify it lists them as , 4) Apply the patch 5) Re-check the pull down in the wizard and check that the vendors are now listed , It worked as described. Signed-off-by: Devinim -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 David Roberts changed: What|Removed |Added Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 --- Comment #1 from David Roberts --- Created attachment 102390 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102390=edit Bug 24940: Serials statistics wizard: order vendor list alphabetically This patch changes the dropdown from being sorted by aqbookseller.id to aqbookseller.name To test: 1) Add at least 2 vendors: - First: - Second: 2) Add subscriptions for each of the vendors 3) Check the pull down in the serials statistics wizard and verify it lists them as , 4) Apply the patch 5) Re-check the pull down in the wizard and check that the vendors are now listed , -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 24940] Serials statistics wizard: order vendor list alphabetically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24940 David Roberts changed: What|Removed |Added CC||david.roberts@ptfs-europe.c ||om Assignee|koha-b...@lists.koha-commun |david.roberts@ptfs-europe.c |ity.org |om -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/