Skip Ribbon Commands
Skip to main content



Work Items: Home > Student Information > Students, "Personal" tab, "Last Name" set to "Brown"

Edit ItemEdit Item
Version HistoryVersion History

Issue Type

Bug - fix a bug in the system


Home > Student Information > Students, "Personal" tab, "Last Name" set to "Brown"


When a report shows students' first and last names in separately sortable columns (which is desirable), then if a user sorts on the last name, the first name should be an implicit secondary sort parameter.  (In other words, in terms of SQL, if a user clicks on the "Last Name" column header, the result SQL clause should be "ORDER BY Last_Name, First_Name", with the appropriate DESC, ASC.)    Otherwise, as has happened, when a user sorts by last name, they might miss a student due to the natural, intuitive assumption that the first names are alphabetized secondarily.  For instance, using the above URL (searching for students with the last name of "Brown"), one might assume that the student with the first name of "Alison" would come first, before "Amy" and "Anna" and "Ashley"; but, "Alison" in fact comes up ninth -- and thus would be missed by most users.    This should be easy to implement and is extremely practical.  Alternately, if one insists on making an interface that is generalizable and thus is resistent to implementing such a practical solution, then the generalizable solution is to allow users to specify multiple columns to be sorted in a specific order (as is done in MS Excel and MS Access).  Either of these solutions would work fine.


1. First Release - Need it now




Related Issues



Fix verified and closed 8/28/13. (Nicely done!) - LJR

Issue Status


Time To Complete











Version: 1.0
Created at 8/23/2013 5:06 PM by Michael Stealey
Last modified at 8/28/2013 9:35 AM by Larry Rosenfeld