cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sampath Uppula <SU0064...@TechMahindra.com>
Subject RE: How to fetch the Distinct rows based on an attribute.
Date Tue, 09 Oct 2012 09:57:12 GMT
Hi,
Thanks for the response.
But this is just an example.
I have many scenarios, where I have to fetch the distinct rows based on a field (attribute).

Can you also please answer the issue# CAY-1730 (https://issues.apache.org/jira/browse/CAY-1730)?

Thanks,
Sampath Uppula


-----Original Message-----
From: Durchholz, Joachim [mailto:Joachim.Durchholz@hennig-fahrzeugteile.de] 
Sent: Tuesday, October 09, 2012 3:06 PM
To: user@cayenne.apache.org
Subject: RE: How to fetch the Distinct rows based on an attribute.

What you want to do does not make sense.
If there are rows that have the same user_id but different fields elsewhere, which of these
rows should be returned?

________________________________

From: Sampath Uppula [mailto:SU0064323@TechMahindra.com] 
Sent: Tuesday, October 09, 2012 10:00 AM
To: user@cayenne.apache.org
Subject: How to fetch the Distinct rows based on an attribute.



Hi,

I have  a table t_user_allocation_details with many columns, one of the column is user_id.

I want to fetch the distinct data based on user_id.

Please suggest a way to achieve this.

 

I have tried the below method but it’s based on all the columns in the table.

 

*	public void setDistinct(boolean distinct)
	If set to true (default is false), tells Cayenne that query should fetch distinct rows. 

 

Thanks,

Sampath Uppula|eConvergence,BT-15|Tech Mahindra

------------------------------------------------------------------------------

S1-W-5572, West Wing, Block-1, Hinjewadi-Phase III, Pune 411 057, INDIA

( Office: +91 20 42250000 Extn: 250879 | Cell: +91 9730745043

Email: SU0064323@techmahindra.com <mailto:SU0064323@techmahindra.com> 

www.techmahindra.com <http://www.techmahindra.com/> 

 

eConvergence

 

============================================================================================================================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 http://www.techmahindra.com/Disclaimer.html
externally and http://tim.techmahindra.com/tim/disclaimer.html internally within Tech Mahindra.============================================================================================================================

============================================================================================================================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.============================================================================================================================
Mime
View raw message