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
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
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.============================================================================================================================
