You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by emeka okafor <em...@yahoo.com> on 2012/12/06 21:27:12 UTC

select distinct ...

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

RE: select distinct ...

Posted by Sampath Uppula <SU...@TechMahindra.com>.
You can see more here:
http://cayenne.apache.org/doc/sqltemplate-result-mapping.html

Thanks,
Sampath Uppula 
________________________________________
From: reich.markus@gmail.com [reich.markus@gmail.com] On Behalf Of Markus Reich [markus.reich@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 <em...@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.reich@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.============================================================================================================================

Re: select distinct ...

Posted by Markus Reich <ma...@markusreich.at>.
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 <em...@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.reich@markusreich.at