Skip to content

Commit 87470d9

Browse files
committed
order meter value entries by timestamp
1 parent 5ccd953 commit 87470d9

1 file changed

Lines changed: 5 additions & 1 deletion

File tree

src/main/java/de/rwth/idsg/steve/repository/impl/TransactionRepositoryImpl.java

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -11,6 +11,7 @@
1111
import org.joda.time.DateTime;
1212
import org.jooq.Condition;
1313
import org.jooq.DSLContext;
14+
import org.jooq.Field;
1415
import org.jooq.Record10;
1516
import org.jooq.Record8;
1617
import org.jooq.RecordMapper;
@@ -136,9 +137,11 @@ public TransactionDetails getDetails(int transactionPk) {
136137
// We are only interested in the first arriving entry.
137138
// -------------------------------------------------------------------------
138139

140+
Field<DateTime> dateTimeField = DSL.min(t1.field(2, DateTime.class)).as("min");
141+
139142
List<TransactionDetails.MeterValues> values =
140143
ctx.select(
141-
DSL.min(t1.field(2, DateTime.class)),
144+
dateTimeField,
142145
t1.field(3, String.class),
143146
t1.field(4, String.class),
144147
t1.field(5, String.class),
@@ -153,6 +156,7 @@ public TransactionDetails getDetails(int transactionPk) {
153156
t1.field(6),
154157
t1.field(7),
155158
t1.field(8))
159+
.orderBy(dateTimeField)
156160
.fetch()
157161
.map(r -> TransactionDetails.MeterValues.builder()
158162
.valueTimestamp(r.value1())

0 commit comments

Comments
 (0)