Re: Problem - fetching the Distinct rows based on a Property

2012-10-30 Thread Andrus Adamchik
tch the data for only few > columns...using the object entity. > > Thanks, > Sampath Uppula > > > -Original Message- > From: Felipe Martín Santos [mailto:gadita...@gmail.com] > Sent: Tuesday, October 30, 2012 4:40 PM > To: user@cayenne.apache.org > Subject: Re:

RE: Problem - fetching the Distinct rows based on a Property

2012-10-30 Thread Sampath Uppula
.using the object entity. Thanks, Sampath Uppula -Original Message- From: Felipe Martín Santos [mailto:gadita...@gmail.com] Sent: Tuesday, October 30, 2012 4:40 PM To: user@cayenne.apache.org Subject: Re: Problem - fetching the Distinct rows based on a Property // Extract is the obj-entit

Re: Problem - fetching the Distinct rows based on a Property

2012-10-30 Thread Felipe Martín Santos
// Extract is the obj-entity you have for the T_QC_EXTRACT db-entity SQLTemplate query = new SQLTemplate(Extract.class, "SELECT DISTINCT STORY_ID FROM T_QC_EXTRACT WHERE EXECUTION_STATUS IN ('PASSED','BLOCKED')"); SQLResult resultDescriptor = new SQLResult(); resultDescriptor.addColumnResult("STOR