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