[airavata] branch master updated: AIRAVATA-3372 Fix to speed up process list query

[ma...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

machristie 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 0fad168  AIRAVATA-3372 Fix to speed up process list query
0fad168 is described below

commit 0fad16881e4d1189933447fae01491a13c6188d7
Author: Marcus Christie <ma...@apache.org>
AuthorDate: Thu Oct 29 11:10:56 2020 -0400

    AIRAVATA-3372 Fix to speed up process list query
---
 .../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 a2c1737..63f1b03 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
@@ -131,7 +131,7 @@ public interface QueryConstants {
             "WHERE E.gatewayId LIKE :" + DBConstants.Experiment.GATEWAY_ID;
 
     String GET_PROCESS_FOR_EXPERIMENT_ID = "SELECT P FROM " + ProcessEntity.class.getSimpleName() + " P " +
-            "WHERE P.experimentId LIKE :" + DBConstants.Process.EXPERIMENT_ID;
+            "WHERE P.experimentId = :" + DBConstants.Process.EXPERIMENT_ID;
 
     String GET_TASK_FOR_PARENT_PROCESS_ID = "SELECT T FROM " + TaskEntity.class.getSimpleName() + " T " +
             "WHERE T.parentProcessId LIKE :" + DBConstants.Task.PARENT_PROCESS_ID;