From 888e2ba877ca4e511deed25e263f3ac036bd636f Mon Sep 17 00:00:00 2001
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Mon, 25 Mar 2013 15:47:58 -0700
Subject: [PATCH] CSPACE-5943: First working SQL query, now returns Nuxeo
 document IDs. Still is hard-coded for Storage Location items.

---
 .../nuxeo/client/java/RepositoryJavaClientImpl.java   | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

diff --git a/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java b/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java
index 8a8196853..19f7aeccd 100644
--- a/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java
+++ b/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java
@@ -927,9 +927,14 @@ public class RepositoryJavaClientImpl implements RepositoryClient<PoxPayloadIn,
         // FIXME: Replace this placeholder query with an actual query from CSPACE-5945
         // FIXME: Consider using a prepared statement here
         String sql =
-                "SELECT id, termdisplayname FROM "
-                + termInfoGroupTableName
-                + " WHERE termdisplayname LIKE '" + partialTerm + "%'";
+                "SELECT DISTINCT hierarchy.id as id " // For debugging add: ", ltg.termdisplayname"
+                + " FROM hierarchy "
+                + " LEFT JOIN hierarchy h1 "
+	        + "   ON h1.parentid = hierarchy.id "
+		+ "   AND h1.name = 'locations_common:locTermGroupList' "
+                + " LEFT JOIN loctermgroup ltg "
+	        + "   ON ltg.id = h1.id "
+                + " WHERE (ltg.termdisplayname ILIKE '" + partialTerm + "%')";
 
         // Make sure autocommit is off. See:
         // http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor
-- 
2.47.3