I don't think this works with SQLite on jooq 3.13.1 . I get a syntax error on "order" when I use listAgg.
On Monday, January 13, 2014 at 6:05:11 AM UTC-5, Lukas Eder wrote: > > This is implemented for jOOQ 3.3. Note that in the mean time, you can also > use plain SQL to work around this missing feature. An example is given in > the Javadoc of DSL.field(): > > http://www.jooq.org/javadoc/3.2.x/org/jooq/impl/DSL.html#field%28java.lang.String,%20java.lang.Class,%20org.jooq.QueryPart...%29 > > In your case: > > field("GROUP_CONCAT({0})", String.class, argument); > > Regards, > Lukas > > 2014/1/13 Lukas Eder <[email protected] <javascript:>> > >> Hello Christian, >> >> You're right, this emulation of MySQL's GROUP_CONCAT should be supported >> by jOOQ. I have registered #2944 for this: >> https://github.com/jOOQ/jOOQ/issues/2944 >> >> Cheers >> Lukas >> >> >> 2014/1/13 <[email protected] <javascript:>> >> >> Hello, >>> >>> I am facing problems with using the groupConcat function in jooq with >>> Sqlite. >>> It is translated by jooq into the 'listagg' SQL function which is not >>> available in Sqlite, therefore the query fails. However the group_concat >>> function is available in Sqlite so jooq should use this function instead. >>> >>> Thanks and best regards >>> >>> Christian >>> >>> -- >>> 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] <javascript:>. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> > -- 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/3ff42e8c-c9d1-456b-b77e-44a6ccf5ddda%40googlegroups.com.
