What's not working? On Tue, Jun 15, 2021 at 3:19 AM Debapriya Patra <[email protected]> wrote:
> This is what I have done following this link. > > > https://www.jooq.org/doc/3.2/manual/sql-building/sql-statements/select-statement/order-by-clause/ > > > dsl.select( > EDU_CONTENT.ID, > EDU_CONTENT.TITLE, > EDU_CONTENT.DESCRIPTION, > EDU_CONTENT.MEDIA_TYPE, > EDU_CONTENT.EDU_DOCUMENT_TYPE, > EDU_CONTENT.CONTENT_STATUS, > EDU_CONTENT.CUSTOM_DOCUMENT_TYPE, > EDU_CONTENT.ORIGINAL_FILE_S3_URL, > EDU_CONTENT.PREVIEW_FILE_S3_URL, > EDU_CONTENT.THUMBNAIL_FILE_S3_URL, > EDU_CONTENT.CREATED_TS, > EDU_CONTENT.UPDATED_TS, > EDU_CONTENT.EXAM_NAME, > EDU_CONTENT.YEAR, > EDU_CONTENT.TERM, > EDU_CONTENT.COMMENT, > EDU_CONTENT.DELETED, > EDU_CONTENT.NUM_PAGES) > .from(EDU_CONTENT) > .where(EDU_CONTENT.ID.in(eduContentIds)) > .orderBy(EDU_CONTENT.CONTENT_STATUS.sortAsc(NEED_MORE_INFO, > PENDING_VERIFICATION, PAYOUT_INITIATED, PAID, SYLLABUS_REQUIRED), > EDU_CONTENT.UPDATED_TS.asc()).limit(50).fetchInto(EduContent.class); > > On Monday, June 14, 2021 at 5:05:22 PM UTC-7 [email protected] wrote: > >> On 6/14/21 6:01 PM, Debapriya Patra wrote: >> >> Hi, >> >> Can someone help me forming a query in jooq which I wrote in MySql? >> Here is my MySql query and wanted to convert the same in Jooq. >> >> *select* *** *from* edu_content *where* id *in* >> ("03bb84c5-0516-44e3-8445-ba0d8dba32e9", >> "050a30fd-b1c3-4767-b453-8cc2d211049b", >> "2941b14c-135a-4866-89e1-e9a43aa368c5", >> "2bc7ffbc-1704-49cb-b28b-b324577598a8", >> "ff6847ac-3a18-4609-8e1b-7dae5ba1e297") *order* *by* field >> (content_status, 'PAID', 'PAYOUT_INITIATED', 'PENDING_VERIFICATION', >> 'SYLLABUS_REQUIRED', 'NEED_MORE_INFO'), updated_ts *asc*; >> Thanks In Advance. >> >> What have you tried? >> >> >> -- > 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/35c7b1e2-346f-4517-9683-b78c71472e12n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/35c7b1e2-346f-4517-9683-b78c71472e12n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAB4ELO60L5fNA%3D1ov-cst6HLtR3nf_Bm%3DpYNyzS4jnPzhSEhFA%40mail.gmail.com.
