public List<? extends ProjectMember> getActiveProjectMembers(long id) {
return create()
.selectFrom(PROJECT_MEMBER)
.where(PROJECT_MEMBER.PROJECT_ID.eq(id))
.and(PROJECT_MEMBER.STATE.eq(CommonStatesConstants.ACTIVE))
.and(PROJECT_MEMBER.REMOVED.isNull())
.orderBy(PROJECT_MEMBER.ID.asc())
.fetch();
}
@Override
public ProjectMember getProjectMember(long id) {
return create().selectFrom(PROJECT_MEMBER).where(PROJECT_MEMBER.ID.eq(id)).fetchOne();
}