On 6/14/21 7:19 PM, Debapriya Patra 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);
and the error is?
I assume "eduContentIds" is a collection of the right type.
Are you assigning to a Collection<EduContent>?
--
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 jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/b9e9a4a9-bf78-4fcd-d15f-57183c3691df%40gmail.com.
