Hibernate Query Question - Get most recent unique rows

From: Julie Robinson <julierobinson(at)dafunks(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Hibernate Query Question - Get most recent unique rows
Date: 2006-03-24 16:58:57
Message-ID: 44242551.8080203@dafunks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Given the two classes at the bottom of this email, I'm having trouble
coming up with a Hibernate query statement that returns a list
representing all rows in the quality_control_reset table where there is
only one row for the most recent quality_control_range. Help?

Example:

In table quality_control_reset, there are the following rows:

id | timestamp | qualitycontrolrange
---------------------------------------------
1 | 02/23/2006 | 20
2 | 02/23/2006 | 6
3 | 02/28/2006 | 18
4 | 03/01/2006 | 18
5 | 03/23/2006 | 12
6 | 03/23/2006 | 20

I want the results of the following from the query:

id | timestamp | qualitycontrolrange
---------------------------------------------
2 | 02/23/2006 | 6
4 | 03/01/2006 | 18
5 | 03/23/2006 | 12
6 | 03/23/2006 | 20

QualityControlReset.java:

package test;

import java.util.Date;

/**
* @hibernate.class table="quality_control_reset"
*/
public class QualityControlReset {
private Date date;
private QualityControlRange qualityControlRange;

public QualityControlReset() {
// noop
}

/**
* @hibernate.id generator-class="native" column="id"
*/
public Long getId() {
return id;
}

public void setId(Long long1) {
id = long1;
}

/**
* @hibernate.property not-null="true"
*/
public Date getDate() {
return date;
}

public void setDate(Date date) {
this.date = date;
}

/**
* @hibernate.many-to-one class="test.QualityControlRange"
cascade="none" not-null="true"
*/
public QualityControlRange getQualityControlRange() {
return qualityControlRange;
}

public void setQualityControlRange(QualityControlRange
qualityControlRange) {
this.qualityControlRange = qualityControlRange;
}
}

QualityControlRange.java:

package test;

/**
* @hibernate.class table="quality_control_range"
*/
public class QualityControlRange {
private String code;

public QualityControlRange() {
}

/**
* @hibernate.id generator-class="native" column="id"
*/
public Long getId() {
return id;
}

public void setId(Long long1) {
id = long1;
}

/**
* @hibernate.property
*/
public String getCode() {
return code;
}

public void setCode(String code) {
this.code = code;
}
}

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-03-24 17:10:00 Re: [GENERAL] A real currency type
Previous Message August Zajonc 2006-03-24 16:54:54 Re: [GENERAL] A real currency type