selecting distinct projects
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/a7ff42e4 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/a7ff42e4 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/a7ff42e4 Branch: refs/heads/develop Commit: a7ff42e4771381b139f05574cf7f1ecebcf73862 Parents: 3315c19 Author: scnakandala <[email protected]> Authored: Mon Jan 4 14:34:34 2016 -0500 Committer: scnakandala <[email protected]> Committed: Mon Jan 4 14:34:34 2016 -0500 ---------------------------------------------------------------------- .../registry/core/experiment/catalog/resources/WorkerResource.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/a7ff42e4/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/resources/WorkerResource.java ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/resources/WorkerResource.java b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/resources/WorkerResource.java index bf04eff..cf2f59b 100644 --- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/resources/WorkerResource.java +++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/resources/WorkerResource.java @@ -513,7 +513,7 @@ public class WorkerResource extends AbstractExpCatResource { List<org.apache.airavata.registry.core.experiment.catalog.resources.ProjectResource> result = new ArrayList<org.apache.airavata.registry.core.experiment.catalog.resources.ProjectResource>(); EntityManager em = null; try { - String query = "SELECT p from Project p WHERE "; + String query = "SELECT DISTINCT p from Project p WHERE "; if (filters != null && filters.size() != 0) { for (String field : filters.keySet()) { String filterVal = filters.get(field);
