Hello Lukas,
how do I write this query correctly?
Wanted:
SELECT o.name, l.comment
FROM customerobjectdb_object AS o,
LATERAL (SELECT * FROM customerobjectdb_history AS h WHERE h.object_id = o.
id
order by h.major_version desc, h.minor_version desc limit 1
) AS l
ORDER BY o.id;
Jooq(not correct)
var fetch = db.select(o.NAME,
//o.STATUS.convertFrom(x -> ObjectSafetyStatus.from(x)),
//o.CHANGED_AT,
//o.VERSION,
lateral(DSL.select(h.COMMENT)
.from(h)
.where(h.OBJECT_ID.eq(o.ID))
.orderBy(h.MAJOR_VERSION.desc(),
h.MINOR_VERSION.desc())
.limit(1)).as("l")
)
.from(o)
.orderBy(o.CHANGED_AT.desc())
.limit(10)
.fetch();
SQL
select "o"."name", row ("l"."comment") as "l"
from "public"."customerobjectdb_object" as "o"
order by "o"."changed_at" desc fetch next ? rows only
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/38f093bf-1ac6-4317-8e19-032eea82685bn%40googlegroups.com.
