Imagine I have a query like:
String someName = ".."
String sql = jooq
.select(
field("first_name"),
field("last_name"))
.from(
table("driver"))
.where(
field("last_name").equal(someName))
.orderBy(
field("first_name").asc())
.getSQL(ParamType.INLINED);
I want to basically reuse this base query to actually:
1) select the count for the given base from/where.
2) extend the query to limit the result set to given page size/offset.
Would it be possible to create some base part query and then change the select
cause (count vs. actual columns) and the where (add pagesize/offset) and
perform the 2 queries?
--
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].
For more options, visit https://groups.google.com/d/optout.
