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 <[email protected]>
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")
