Bug 22260 - Incorrect GROUP BY in spent and ordered pages in Acquisitions
Summary: Incorrect GROUP BY in spent and ordered pages in Acquisitions
Status: RESOLVED DUPLICATE of bug 21622
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Nick Clemens
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-02-01 14:14 UTC by Nick Clemens
Modified: 2019-02-21 16:40 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 22260: Incorrect GROUP BY in spent and ordered pages in Acquisitions (2.46 KB, patch)
2019-02-01 14:14 UTC, Nick Clemens
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Nick Clemens 2019-02-01 14:14:00 UTC
To recreate:
1 - Have some budgets and orders
2 - Visit acqui/acqui-home.pl
3 - looks fine
4 - click on either the spent or ordered column for a fund
5 - Internal server error
Comment 1 Nick Clemens 2019-02-01 14:14:46 UTC
Created attachment 84628 [details] [review]
Bug 22260: Incorrect GROUP BY in spent and ordered pages in Acquisitions

To test:
1 - Have some budgets and orders
2 - Visit acqui/acqui-home.pl
3 - looks fine
4 - click on either the spent or ordered column for a fund
5 - Internal server error
6 - Apply patch (restart all the things)
7 - Both links now work
8 - Verify totals are correct
Comment 2 Pierre-Marc Thibault 2019-02-08 21:54:54 UTC
When I go on acqui-home.pl, I see the table "All available funds for Bibliothèque" with two funds and the columns Ordered and Spent, but there are no arrows to sort them. Am I suppose to see them? because otherwise when I click on the columns, nothing happens.
Comment 3 Katrin Fischer 2019-02-09 08:54:54 UTC
What is meant here is to click directly on the amounts (they have to be different from 0) and you will go to a lit of orders for each ordered or received items.
Comment 4 Nick Clemens 2019-02-21 16:40:39 UTC

*** This bug has been marked as a duplicate of bug 21622 ***