How to use DSL.val with custom enum type

Hi, I have upgraded to jooq 3.19.8 and I have an enum, e.g. forcedType { userType = 'com.example.IndexType' enumConverter = true includeExpression = '(?i:search\\.example\\.type)' } Then I want to use this enum with DSL.val() in db.select( EXAMPLE.ID, DSL.val(IndexType.SOMETHING)) .from(EXAMPLE)

Re: How to use DSL.val with custom enum type

Hi Petar, A DataType instance is available from your SEARCH.EXAMPLE.TYPE column, for example. It might be available elsewhere, too. You can create it as well manually in various ways, e.g. SQLDataType.VARCHAR.asConvertedDataType(...). I hope this helps, Lukas On Mon, May 6, 2024 at 2:29 PM Petar

Re: How to use DSL.val with custom enum type

Thanks Lukas, it works On Monday, May 6, 2024 at 2:32:22 PM UTC+2 Lukas Eder wrote: > Hi Petar, > > A DataType instance is available from your SEARCH.EXAMPLE.TYPE > column, for example. It might be available elsewhere, too. You can create > it as well manually in various ways, e.g. > SQLDataTy

Re: How to use DSL.val with custom enum type

Thanks for your feedback. I've created an issue to improve the warning message to include these hints: https://github.com/jOOQ/jOOQ/issues/16656 On Tue, May 7, 2024 at 7:16 AM Petar Andreev wrote: > Thanks Lukas, it works > > On Monday, May 6, 2024 at 2:32:22 PM UTC+2 Lukas Eder wrote: > >> Hi P