[HepData-svn] r1487 - trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query

[blackhole at projects.hepforge.org]

Author: whalley
Date: Tue Nov 15 14:11:24 2011
New Revision: 1487

Log:
change order for all record display to date

Modified:
   trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java

Modified: trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java
==============================================================================
--- trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java	Fri Nov 11 14:35:46 2011	(r1486)
+++ trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java	Tue Nov 15 14:11:24 2011	(r1487)
@@ -976,7 +976,8 @@
 	    else{
 	        b.append("select distinct pa from Paper pa");
             }
-            b.append(" order by pa._spiresId desc");
+            b.append(" join pa._references ref");
+            b.append(" order by ref._date desc");
      	    q = _session.createQuery(b.toString());
 	}