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:[email protected]] Sent: Tuesday, October 09, 2012 10:00 AM To: [email protected] 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: [email protected] <mailto:[email protected]> 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.============================================================================================================================
