[LON-CAPA-cvs] cvs: loncom /interface loncoursedata.pm

[raeburn]

raeburn		Sun Mar 11 12:44:23 2018 EDT

  Modified files:              
    /loncom/interface	loncoursedata.pm 
  Log:
  - For &rank_students_by_scores_on_resources() include a secondary sort 
    (arbitrarily chosen to be by username) so rank for users with the same score
    is invariant between calls.
  
  
Index: loncom/interface/loncoursedata.pm
diff -u loncom/interface/loncoursedata.pm:1.202 loncom/interface/loncoursedata.pm:1.203
--- loncom/interface/loncoursedata.pm:1.202	Mon Dec 18 23:51:14 2017
+++ loncom/interface/loncoursedata.pm	Sun Mar 11 12:44:22 2018
@@ -1,6 +1,6 @@
 # The LearningOnline Network with CAPA
 #
-# $Id: loncoursedata.pm,v 1.202 2017/12/18 23:51:14 raeburn Exp $
+# $Id: loncoursedata.pm,v 1.203 2018/03/11 12:44:22 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -1933,7 +1933,7 @@
         $limits =~ s/( AND )$//;   # Remove extra conjunction
         $request .= "WHERE $limits";
     } 
-    $request .= " $award_clause GROUP BY a.student_id ORDER BY score";
+    $request .= " $award_clause GROUP BY a.student_id ORDER BY score, b.student";
     #&Apache::lonnet::logthis('request = '.$/.$request);
     my $sth = $dbh->prepare($request) or die "Can't prepare $request";
     $sth->execute();