Use CTW in Ebean ORM

[danu...@gmail.com]

Hi Guys,

I just wanna ask, is it possible to use CTE in Raw SQL Query in Ebean ORM?

I've tried with find() and RawSqlBuilder, but there is an error "Query must be start with select".

Any other way?



Regards,



Argi

[Rob Bygrave]

RawSqlBuilder has the unparsed() option so you could use that instead of parse().

Alternatively, use findNative() ... which does automatic mapping of columns using jdbc meta data. 

Refer to: https://ebean.io/docs/query/findNative

Cheers, Rob.