I'm trying to implement qualify using
var result2 = ctx.select(PRODUCT_MASTER.PRODUCT_LINE,
PRODUCT_MASTER.PRODUCT_NAME, PRODUCT_MASTER.PRODUCT_SCALE)
.from(PRODUCT_MASTER)
.qualify(rowNumber().over().orderBy(PRODUCT_MASTER.PRODUCT_LINE.desc()).between(start,
end))
.fetchInto(ProductMaster.class)
But I'm getting data access exception saying it is not available for OSS,
but Saw some links like this
<https://www.jooq.org/doc/latest/manual/sql-building/sql-statements/select-statement/qualify-clause/>
which
show it can be used with OSS. Some other examples like this
<https://www.jooq.org/doc/latest/manual/sql-building/column-expressions/window-functions/window-order/>
and
this
<https://www.jooq.org/doc/latest/manual/sql-building/column-expressions/window-functions/window-frame/>
showing
it is available for OSS. Possibly I'm missing something, or a simple part
of the above that is not OSS?
--
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/45ef384a-0c45-43a1-a427-0238e7364120n%40googlegroups.com.
