From 3bcf0df844bcf3fffdc4874301dc26df266ac9f9 Mon Sep 17 00:00:00 2001 From: Roland Haeder Date: Wed, 21 Oct 2015 12:27:50 +0200 Subject: [PATCH] =?utf8?q?fixed=20query=20for=20new=20design=20+=20renamed?= =?utf8?q?=20it=20Signed-off-by:Roland=20H=C3=A4der=20?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- .../model/addressbook/entry/UserAddressbookEntry.java | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/org/mxchange/addressbook/model/addressbook/entry/UserAddressbookEntry.java b/src/org/mxchange/addressbook/model/addressbook/entry/UserAddressbookEntry.java index 3b73258..c858c27 100644 --- a/src/org/mxchange/addressbook/model/addressbook/entry/UserAddressbookEntry.java +++ b/src/org/mxchange/addressbook/model/addressbook/entry/UserAddressbookEntry.java @@ -48,8 +48,8 @@ import org.mxchange.jcontactsbusiness.CompanyContact; @Table (name = "addressbook_entries") @NamedQueries ( @NamedQuery ( - name = "AllAddressbookEntries", - query = "SELECT e FROM addressbook_entries AS e WHERE e.addressbookId = :addressbook AND (e.addressbookEntryUserOwner = :owner OR e.addressbookEntryUserSharer = :sharer) ORDER BY e.addressbookEntryId ASC") + name = "SearchUsersAddressbookEntries", + query = "SELECT e FROM addressbook_entries AS e INNER JOIN addressbooks AS a ON e.addressbookId = a.addressbookId WHERE e.addressbookId = :addressbook AND a.addressbookUser = :owner ORDER BY e.addressbookEntryId ASC") ) public class UserAddressbookEntry implements AddressbookEntry, Comparable { -- 2.39.5