[Koha-bugs] [Bug 6710] lists of lists in Alpha order

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6710

Owen Leonard <oleonard at myacpl.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Templates                   |Virtual Shelves
         AssignedTo|oleonard at myacpl.org         |gmcharlt at gmail.com
          QAContact|koha-bugs at lists.koha-commun |ian.walls at bywatersolutions.
                   |ity.org                     |com

--- Comment #1 from Owen Leonard <oleonard at myacpl.org> 2011-11-11 17:15:47 UTC ---
The lists that display in those instances are generated by the GetRecentShelves
subroutine which retrieves (usually 10) shelve ordered by the date last
modified:

    my $query = 'SELECT * FROM virtualshelves';
    $query .= $selection;
    $query .= ' ORDER BY lastmodified DESC';
    if ($row_count){
    $query .= ' LIMIT ?';

So the top of the list should be the most recently changed.

Perhaps it would be better to grab the last 10 most recently changed and
reorder the resulting set by title?

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
You are watching all bug changes.