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*
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4378 (20090828) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users