Slide 27
Slide 27 text
FOSDEM - @marcoGomier
EmailThreadTable.join(EmailFolderTable, JoinType.INNER, additionalConstraint = {
(EmailThreadTable.id eq EmailFolderTable.threadId).and(
EmailThreadTable.account eq EmailFolderTable.accountId
)
})
.select { EmailThreadTable.account eq account.id.value and (EmailFolderTable.folderId eq folderId) }
.orderBy(EmailThreadTable.lastEmailDate, SortOrder.DESC)
.limit(n = pageSize)