QVTrace trace = QVTrace.vTrace;
QVTrace subTrace = QVTrace.vTrace;
DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
SubQueryExpression<LocalDateTime> query = JPAExpressions.select(subTrace.recordTime)
.from(subTrace).where(subTrace.id.eq(trace.id)).orderBy(subTrace.recordTime.desc()).limit(1);
List<Map<String, Object>> list = getQueryFactory().select(trace.id,trace.name,query)
.from(trace)
.where(trace.userId.eq(userId))
.orderBy(trace.recordTime.desc())
.fetch()
.stream()
.map(tuple -> {
Map<String, Object> map = new HashMap<String, Object>();
map.put("id", tuple.get(trace.id));
map.put("name", tuple.get(trace.name));
map.put("recordTime", tuple.get(query).format(df));
return map;
}).collect(Collectors.toList());
我是这样实现的 但是发现结果不对