From b18e7d73233781383e95d1098e04d940dc8ab60d Mon Sep 17 00:00:00 2001 From: Roland Haeder Date: Sat, 12 Mar 2016 19:19:35 +0100 Subject: [PATCH] Added named query AllEmailAddressChanges --- .../jusercore/model/email_address/EmailAddressChange.java | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/src/org/mxchange/jusercore/model/email_address/EmailAddressChange.java b/src/org/mxchange/jusercore/model/email_address/EmailAddressChange.java index 28e11bc..492739a 100644 --- a/src/org/mxchange/jusercore/model/email_address/EmailAddressChange.java +++ b/src/org/mxchange/jusercore/model/email_address/EmailAddressChange.java @@ -46,7 +46,10 @@ import org.mxchange.jusercore.model.user.User; @Entity (name = "email_changes") @Table (name = "email_changes") @NamedQueries ( - @NamedQuery (name = "SearchEmailChangeByEmail", query = "SELECT e FROM email_changes AS e WHERE LOWER(e.emailAddress) LIKE LOWER(:email)") + value = { + @NamedQuery (name = "SearchEmailChangeByEmail", query = "SELECT e FROM email_changes AS e WHERE LOWER(e.emailAddress) LIKE LOWER(:email)"), + @NamedQuery (name = "AllEmailAddressChanges", query = "SELECT e.emailAddress FROM email_changes AS e ORDER BY e.emailChangeId ASC") + } ) public class EmailAddressChange implements ChangeableEmailAddress { -- 2.39.5