public List<Contacts>
recentTouches(Subuser subuser)
{
Query query = em.createQuery("SELECT
DISTINCT h.contact FROM History h WHERE h.subuser = :subuser ORDER BY
h.id
DESC");
query.setParameter("subuser",
subuser);
query.setMaxResults(10);
return query.getResultList();
}
Generates the following sql
SELECT DISTINCT t0.contactid, t0.fullname,
t0.firstname,
t0.lastname, t0.salutation, t0.title, t0.email, t0.mailingaddressline1,
t0.mailingaddressline2,
t0.mailingaddressline3, t0.city, t0.province, t0.postalcode,
t0.country,
t0.company, t0.businessphone, t0.businessfax, t0.mobilephone,
t0.homephone,
t0.businessphoneext, t0.smsphone, t0.leadsource, t0.birthdate,
t0.emailoptout,
t0.create_date, t0.last_modified, t1.id
FROM history t1 LEFT OUTER JOIN contacts t0 ON (t0.contactid =
t1.contactid)
WHERE (t1.subuserid = ?) ORDER BY t1.id DESC
For whatever reason, it has added in t1.id in
to the list
of items selected…. So the number of results from the above function
varies depending if there are any duplicate contacts in the top 10
results
returned from the query… why is it adding t1.id to the select
list? I don’t care about its value….
Derek Knapp
