File tree Expand file tree Collapse file tree
src/main/java/de/rwth/idsg/steve/repository/impl Expand file tree Collapse file tree Original file line number Diff line number Diff line change 1111import org .joda .time .DateTime ;
1212import org .jooq .Condition ;
1313import org .jooq .DSLContext ;
14+ import org .jooq .Field ;
1415import org .jooq .Record10 ;
1516import org .jooq .Record8 ;
1617import 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 ())
You can’t perform that action at this time.
0 commit comments