You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ma...@apache.org on 2017/08/03 16:01:53 UTC
[37/50] [abbrv] airavata git commit: orderby clause in experiment
search
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/master
Commit: fe6e9a25763db27c5cc5f780848a0c6993df7627
Parents: 704ba66
Author: scnakandala <su...@gmail.com>
Authored: Tue Jul 18 13:43:23 2017 -0400
Committer: scnakandala <su...@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;