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/d2d72e52 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/d2d72e52 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/d2d72e52 Branch: refs/heads/develop Commit: d2d72e52b2f4475ec179abce180710527de3d7f7 Parents: 6d09915 Author: scnakandala <[email protected]> Authored: Mon Jan 4 14:34:34 2016 -0500 Committer: scnakandala <[email protected]> Committed: Mon Jan 4 14:36:03 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/d2d72e52/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);
