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

[blackhole at projects.hepforge.org]

Author: whalley
Date: Tue Oct  1 16:51:27 2013
New Revision: 1644

Log:
ordering of Experiment only page

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	Wed Sep 25 09:37:46 2013	(r1643)
+++ trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java	Tue Oct  1 16:51:27 2013	(r1644)
@@ -512,13 +512,16 @@
      	   b.append("select distinct p from Paper p");
        }
        b.append(" join p._experiments exp");
+       b.append(" join p._references ref");
        b.append(" where (exp._name like '%");
        b.append(experiment);
        b.append("%'");
        b.append(" or exp._informalName like '%");
        b.append(experiment);
        b.append("%')");
-       b.append(" order by p._spiresId desc");
+           b.append(" and ref._date > 1900");
+//       b.append(" order by p._spiresId desc");
+            b.append(" order by ref._date desc");
        q = _session.createQuery(b.toString());
 //       System.out.println(q.toString());
 //       q.setString("exp",theExp);