You can see more here: http://cayenne.apache.org/doc/sqltemplate-result-mapping.html
Thanks, Sampath Uppula ________________________________________ From: reich.mar...@gmail.com [reich.mar...@gmail.com] On Behalf Of Markus Reich [markus.re...@markusreich.at] Sent: Friday, December 07, 2012 2:35 AM To: user@cayenne.apache.org; emeka okafor Subject: Re: select distinct ... Hi, just take a look at the SelectQuery Options http://cayenne.apache.org/docs/3.0/selectquery-customization.html regards Meex 2012/12/6 emeka okafor <emeka_1...@yahoo.com> > Is there such thing as select distinct in cayenne? I would like to remove > duplicate objects based on a specific column. What is the best way to do it > in cayenne? > Should I have to filter them in memory or is there another way? > Thanks -- *Markus Reich* Moosbach 28/2 6392 St. Jakob i.H. www.markusreich.at / www.meeximum.at markus.re...@markusreich.at ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/tim/disclaimer.html">http://tim.techmahindra.com/tim/disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================