From 32270211a83b0be1695f601d90fe3bba876977b3 Mon Sep 17 00:00:00 2001
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Wed, 27 Mar 2013 18:34:47 -0700
Subject: [PATCH] CSPACE-5943: Added join on database tables for the common
 parts of authority item records.

---
 .../services/nuxeo/client/java/RepositoryJavaClientImpl.java    | 2 ++
 1 file changed, 2 insertions(+)

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 03b065480..64f90839e 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
@@ -929,6 +929,8 @@ public class RepositoryJavaClientImpl implements RepositoryClient<PoxPayloadIn,
 	        + "  ON h1.parentid = hierarchy.id "
                 + " LEFT JOIN " + handler.getJDBCQueryParams().get(JDBC_TABLE_NAME_PARAM) + " tg "
 	        + "   ON tg.id = h1.id "
+                + " LEFT JOIN " + handler.getServiceContext().getCommonPartLabel() + " commonschema "
+	        + "   ON commonschema.id = hierarchy.id "
                 + " LEFT JOIN misc "
 	        + "   ON misc.id = hierarchy.id "
                 + " WHERE (tg.termdisplayname ILIKE ?) "
-- 
2.47.3