const validThreadMessages = await db
.selectDistinctOn([threadMessage.threadId], {
id: threadMessage.id,
threadId: threadMessage.threadId,
createDate: threadMessage.createDate,
})
.from(threadMessage)
.where(
sql`${threadMessage.createDate} > current_date - interval '${interval} days`
)
.orderBy(desc(threadMessage.threadId), desc(threadMessage.createDate))
const validThreadMessages = await db
.selectDistinctOn([threadMessage.threadId], {
id: threadMessage.id,
threadId: threadMessage.threadId,
createDate: threadMessage.createDate,
})
.from(threadMessage)
.where(
sql`${threadMessage.createDate} > current_date - interval '${interval} days`
)
.orderBy(desc(threadMessage.threadId), desc(threadMessage.createDate))