You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by la...@apache.org on 2026/06/18 21:31:06 UTC
(airavata) branch master updated: null-safe ExperimentSummary view
This is an automated email from the ASF dual-hosted git repository.
lahirujayathilake pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/master by this push:
new ce471241bc null-safe ExperimentSummary view
ce471241bc is described below
commit ce471241bc57c4ca36e8847468cff1e0481af91c
Author: lahiruj <la...@gmail.com>
AuthorDate: Thu Jun 18 17:30:58 2026 -0400
null-safe ExperimentSummary view
---
.../apache/airavata/research/model/ExperimentSummaryEntity.java | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/airavata-api/research-service/src/main/java/org/apache/airavata/research/model/ExperimentSummaryEntity.java b/airavata-api/research-service/src/main/java/org/apache/airavata/research/model/ExperimentSummaryEntity.java
index 7326dc112e..e1e167be56 100644
--- a/airavata-api/research-service/src/main/java/org/apache/airavata/research/model/ExperimentSummaryEntity.java
+++ b/airavata-api/research-service/src/main/java/org/apache/airavata/research/model/ExperimentSummaryEntity.java
@@ -39,11 +39,11 @@ import org.hibernate.annotations.Synchronize;
@Subselect("select e.EXPERIMENT_ID as EXPERIMENT_ID, e.PROJECT_ID as PROJECT_ID,"
+ " e.GATEWAY_ID as GATEWAY_ID, e.CREATION_TIME as CREATION_TIME, e.USER_NAME as USER_NAME,"
+ " e.EXPERIMENT_NAME as EXPERIMENT_NAME, e.DESCRIPTION as DESCRIPTION, e.EXECUTION_ID as EXECUTION_ID,"
- + " (select s.STATE from EXPERIMENT_STATUS s where s.EXPERIMENT_ID = e.EXPERIMENT_ID"
- + " order by s.TIME_OF_STATE_CHANGE desc limit 1) as STATE,"
- + " (select prs.RESOURCE_HOST_ID from PROCESS p"
+ + " COALESCE((select s.STATE from EXPERIMENT_STATUS s where s.EXPERIMENT_ID = e.EXPERIMENT_ID"
+ + " order by s.TIME_OF_STATE_CHANGE desc limit 1), '') as STATE,"
+ + " COALESCE((select prs.RESOURCE_HOST_ID from PROCESS p"
+ " join PROCESS_RESOURCE_SCHEDULE prs on prs.PROCESS_ID = p.PROCESS_ID"
- + " where p.EXPERIMENT_ID = e.EXPERIMENT_ID order by p.CREATION_TIME desc limit 1) as RESOURCE_HOST_ID,"
+ + " where p.EXPERIMENT_ID = e.EXPERIMENT_ID order by p.CREATION_TIME desc limit 1), '') as RESOURCE_HOST_ID,"
+ " (select s.TIME_OF_STATE_CHANGE from EXPERIMENT_STATUS s where s.EXPERIMENT_ID = e.EXPERIMENT_ID"
+ " order by s.TIME_OF_STATE_CHANGE desc limit 1) as TIME_OF_STATE_CHANGE"
+ " from EXPERIMENT e")