[Koha-bugs] [Bug 27813] Purchase suggestions should sort by suggesteddate rather than title

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

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

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #6 from David Nind <david at davidnind.com> ---
Testing notes
~~~~~~~~~~~~~

Before  applying the patch I couldn't figure out the default order that
suggestions were sorting in, it wasn't by date and it wasn't by title.

After applying the patch it now sorts by date by default, with the latest
suggestions at the top of the list (that is, sorting by date with the
latest/newest suggestions first).

SQL statements (on koha-testing-docker - koha-mysql kohadev to get into the
database):
- select * from suggestions;
- update suggestions set suggesteddate="YYYY-MM-DD" where suggestionid="#"; 
- where YYYY-MM-DD is the new date, and # is the suggestionid in the database

-- 
You are receiving this mail because:
You are watching all bug changes.