await db
.select({
customerFileId: customer_file.id,
referenceId: customer_file.reference_id,
state: customer_file.state,
backwardStates: customer_file.backward_states,
forwardStates: customer_file.forward_states,
cancelStates: customer_file.cancel_states,
dateCreated: customer_file.date_created,
// All comulns from user table
})
.from(customer_file)
.innerJoin(user, eq(customer_file.owner_id, user.id))
.where(and(eq(customer_file.id, customer_file_id), sql`${customer_file.date_created} > NOW() - INTERVAL '10 days'`))
await db
.select({
customerFileId: customer_file.id,
referenceId: customer_file.reference_id,
state: customer_file.state,
backwardStates: customer_file.backward_states,
forwardStates: customer_file.forward_states,
cancelStates: customer_file.cancel_states,
dateCreated: customer_file.date_created,
// All comulns from user table
})
.from(customer_file)
.innerJoin(user, eq(customer_file.owner_id, user.id))
.where(and(eq(customer_file.id, customer_file_id), sql`${customer_file.date_created} > NOW() - INTERVAL '10 days'`))