airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scnakand...@apache.org
Subject [1/2] airavata git commit: orderby clause in experiment search
Date Tue, 18 Jul 2017 17:43:47 GMT
Repository: airavata
Updated Branches:
  refs/heads/develop a0a66dc53 -> edd1dbbc3


orderby clause in experiment search


Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/fe6e9a25
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/fe6e9a25
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/fe6e9a25

Branch: refs/heads/develop
Commit: fe6e9a25763db27c5cc5f780848a0c6993df7627
Parents: 704ba66
Author: scnakandala <supun.nakandala@gmail.com>
Authored: Tue Jul 18 13:43:23 2017 -0400
Committer: scnakandala <supun.nakandala@gmail.com>
Committed: Tue Jul 18 13:43:23 2017 -0400

----------------------------------------------------------------------
 .../sharing/registry/db/repositories/EntityRepository.java         | 2 ++
 1 file changed, 2 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/airavata/blob/fe6e9a25/modules/sharing-registry/sharing-registry-server/src/main/java/org/apache/airavata/sharing/registry/db/repositories/EntityRepository.java
----------------------------------------------------------------------
diff --git a/modules/sharing-registry/sharing-registry-server/src/main/java/org/apache/airavata/sharing/registry/db/repositories/EntityRepository.java
b/modules/sharing-registry/sharing-registry-server/src/main/java/org/apache/airavata/sharing/registry/db/repositories/EntityRepository.java
index b65481d..ecc5270 100644
--- a/modules/sharing-registry/sharing-registry-server/src/main/java/org/apache/airavata/sharing/registry/db/repositories/EntityRepository.java
+++ b/modules/sharing-registry/sharing-registry-server/src/main/java/org/apache/airavata/sharing/registry/db/repositories/EntityRepository.java
@@ -130,6 +130,8 @@ public class EntityRepository extends AbstractRepository<Entity, EntityEntity,
E
         }
 
         query = query.substring(0, query.length() - 5);
+        query += " ORDER BY p."+DBConstants.EntityTable.ORIGINAL_ENTITY_CREATION_TIME+" DESC";
+
         final String nativeQuery = query;
         int newLimit = limit < 0 ? DBConstants.SELECT_MAX_ROWS: limit;
 


Mime
View raw message