You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by is...@apache.org on 2023/02/01 16:50:59 UTC
[airavata] branch develop updated: query modification
This is an automated email from the ASF dual-hosted git repository.
isjarana pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/develop by this push:
new 51befb362e query modification
new 3ada9dbfe2 Merge pull request #379 from isururanawaka/metaschedular
51befb362e is described below
commit 51befb362ede43bdd0e2b67414d6e1d8334cd5f3
Author: Isuru Ranawaka <ir...@gmail.com>
AuthorDate: Wed Feb 1 11:44:31 2023 -0500
query modification
---
.../java/org/apache/airavata/registry/core/utils/QueryConstants.java | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/utils/QueryConstants.java b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/utils/QueryConstants.java
index 18b53db36d..a6a4e1c027 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/utils/QueryConstants.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/utils/QueryConstants.java
@@ -199,7 +199,7 @@ public interface QueryConstants {
String DELETE_JOB_NATIVE_QUERY = "DELETE FROM JOB WHERE JOB_ID = ?1 AND TASK_ID = ?2";
- String FIND_JOB_COUNT_NATIVE_QUERY = "SELECT DISTINCT JS FROM JOB_STATUS JS WHERE JS.JOB_ID IN " +
+ String FIND_JOB_COUNT_NATIVE_QUERY = "SELECT DISTINCT JS.JOB_ID FROM JOB_STATUS JS WHERE JS.JOB_ID IN " +
"(SELECT J.JOB_ID FROM JOB J where J.PROCESS_ID IN " +
"(SELECT P.PROCESS_ID FROM PROCESS P where P.EXPERIMENT_ID IN " +
"(SELECT E.EXPERIMENT_ID FROM EXPERIMENT E where E.GATEWAY_ID= ?1))) " +