No worries. Some of those methods are available off the field name as well. I'm not sure about the year/month but you could probably do something like
TABLE.MYBIGINT.sum() that's just a preference on your end on what you find more readable, the end result I believe is about the same. On Fri, Dec 23, 2016 at 5:15 PM, Christian Master <[email protected]> wrote: > Thx Samir, this works. > > Connection conn = DriverManager.getConnection("jdb........ > > Result<Record3<Integer, Integer, BigDecimal>> fetch1 > = DSL.using(conn) > .select(DSL.year(TABLE.DATE), > DSL.month(TABLE.DATE), > DSL.sum(TABLE.MYBIGINT)) > .from(TABLE) > .groupBy(DSL.year(TABLE.DATE), > DSL.month(TABLE.DATE)) > .orderBy(DSL.year(TABLE.DATE), > DSL.month(TABLE.DATE)) > .fetch(); > > > Am Freitag, 23. Dezember 2016 04:58:19 UTC+1 schrieb Samir Faci: >> >> I think what you're looking for is: >> DSL.year(), DSL.month() and DSL.sum() respectively. >> > -- > 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. > -- Thank you Samir Faci https://keybase.io/csgeek -- 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.
