const selectResult = await db
.select({
userId: users.id,
organizationMembershipId: organizationMemberships.id,
joinedOrganization: organizationMemberships.createdAt,
firstName: users.firstName,
lastName: users.lastName,
emailAddress: users.emailAddress,
phoneNumber: users.phoneNumber,
imageUrl: users.imageUrl,
lastSignIn: users.lastSignIn,
role: organizationMemberships.role,
count: count(),
})
.from(organizationMemberships)
.innerJoin(users, eq(organizationMemberships.userId, users.id))
.limit(pagination.pageSize)
.offset(pagination.pageIndex * pagination.pageSize)
.groupBy(sql`${users.id}, ${organizationMemberships.id}`);
const selectResult = await db
.select({
userId: users.id,
organizationMembershipId: organizationMemberships.id,
joinedOrganization: organizationMemberships.createdAt,
firstName: users.firstName,
lastName: users.lastName,
emailAddress: users.emailAddress,
phoneNumber: users.phoneNumber,
imageUrl: users.imageUrl,
lastSignIn: users.lastSignIn,
role: organizationMemberships.role,
count: count(),
})
.from(organizationMemberships)
.innerJoin(users, eq(organizationMemberships.userId, users.id))
.limit(pagination.pageSize)
.offset(pagination.pageIndex * pagination.pageSize)
.groupBy(sql`${users.id}, ${organizationMemberships.id}`);