Hibernate Query Question - Get most recent unique rows

Поиск
Список
Период
Сортировка
От Julie Robinson
Тема Hibernate Query Question - Get most recent unique rows
Дата
Msg-id 44242551.8080203@dafunks.com
обсуждение исходный текст
Ответы Re: Hibernate Query Question - Get most recent unique rows  (Julie Robinson <julierobinson@dafunks.com>)
Список 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;
    }
}

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Advantages of PostgreSQL over MySQL 5.0
Следующее
От: Mary Adel
Дата:
Сообщение: pgadmin