Hi Manuel, Yes, the view approach is a very good one. The jOOQ code generator will deal with your view as with any other table. If you plan to re-use the idea of an ALL_RES_ASSIGNMENTS object, then database views would be my recommended solution.
Thanks, Lukas 2018-02-26 23:10 GMT+01:00 Manuel Rossetti <[email protected]>: > Also, how does jOOQ handle views. Could I create a view of the union > query and then reference the view. > > CREATE VIEW ALL_RES_ASSIGNMENTS (RESOURCEID_FK) AS > (SELECT RESOURCEID_FK FROM RES_ISSUE_ASSIGNMENT > UNION > SELECT RESOURCEID_FK FROM RES_RECEIPT_ASSIGNMENT); > > SELECT * > FROM RESOURCE > WHERE NOT EXISTS (select * from ALL_RES_ASSIGNMENTS where RESOURCE.ID = > RESOURCEID_FK); > > That is, can I reference a created view in jooq like a table? > -- 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.
